What are the challenges you face when working across database platforms? Take the survey

How to search for #

bethbeth Posts: 6 New member
edited November 14, 2016 12:15PM in SQL Search
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


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Hi, thank you for your support request.

    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    bethbeth Posts: 6 New member
    thank you Eddie
Sign In or Register to comment.