Varaibles

[IanT]

Hi

I am using the code below to create variables for us in a SQL statement. I am having problems as the strInList variable will be like (*) using the code below instead of Like "*" which is what I need, can anyone advise!



strLike = "Like"
strStar = "*"



strInList = strLike & strStar

 

[jdraw]

Perhaps

strInList = strLike &" '" & strStar & "' "


Good tutorial at http://www.fontstuff.com/access/acctut15.htm

 

[boblarson]

Use this instead:

strInList = strLike & Chr(34) & Chr(42) & Chr(34)