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

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

Comments

  • 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
    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.