How to search for #
beth
Posts: 6 New member
Is it possible to search for #? I am trying to find objects that create temp tables but have not been able to construct a search string that works.
I have tried;
create table #
create AND table AND #
insert AND into AND #
into AND #
and other variations
All of the above return results, but the results may or may not have a "#".
Is SQL Search seeing # as a wildcard? If yes, is there an escape sequence that can be used to force SQL Search to see # as a character?
thank you
I have tried;
create table #
create AND table AND #
insert AND into AND #
into AND #
and other variations
All of the above return results, but the results may or may not have a "#".
Is SQL Search seeing # as a wildcard? If yes, is there an escape sequence that can be used to force SQL Search to see # as a character?
thank you
Comments
Sadly in the current version of SQL Search V2.3.1.388 you cannot search using the # character. SQL Search ignores this character.
Therefore I have submitted a new enhancement request for SQL Search to be able to use the # character as a search parameter. The reference for this request is SDI-699.
Other characters that are ignored are as follows: * , _ , £ and $. There are already future requests in place to support these 4 characters.
The wild card character for SQL Search is the % character. This help ARTICLEcontains information on the wildcard and using the AND?OR operators in the 'Advanced search syntax' paragraph.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com