How to use sql wildcards

[KenWilton]

I am using the Labview SQL sub-set and am trying to construct an sql query using wildcards. ie LIKE 'Pass*' However, none of the MS Access Driver wildcards appear to work with the SQL sub-set. Any suggestions?

[TN]

Hi,

I have some links for you. The first linke gives you info how you Specify a Wildcard Character with the SQL Toolkit and the second one is about "Using the LIKE keyword in a SQL query ". I hope it helps.

http://digital.ni.com/public.nsf/websearch/8854A9FF0CB48A71862566020067BD09?OpenDocument

http://forums.ni.com/ni/board/message?board.id=250&message.id=4926&requireLogin=False

TN