How can we help you today? How can we help you today?

How to search for #

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
beth
0

Comments

2 comments

Sort by
  • Eddie D
    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 D
    0
  • beth
    thank you Eddie
    beth
    0

Add comment

Please sign in to leave a comment.