SQL Wildcard Issue

[AndrewT]

I am having a problem with the following lines:

Code: Select all

GetDialogProperty>PartLookUpDialog,PartCode,Text,varCode
GetDialogProperty>PartLookUpDialog,PartDesc,Text,varDescrip
Let>PartStr=Select Products.Code, Products."Desc" From "Products" where (Products.Code Like '%varCode%%') and (Products."Desc" Like '%varDescrip%%')

I want the extra % after the variable value for a "begins with" search, but the result I see in the Watch List window is:

Code: Select all

0: PARTSTR=Select Products.Code, Products."Desc" From "Products" where (Products.Code Like '%') and (Products."Desc" Like '%varDescrip%%')
0: VARDESCRIP=USE
0: VARCODE=

I think the extra % wildcards are confusing MS as to what is a variable and what isn't.

Anyone know a way around this?

Thanks
Andrew

[JRL]

Try using a variable whose value is "%"

Code: Select all

Let>percent=%
GetDialogProperty>PartLookUpDialog,PartCode,Text,varCode
GetDialogProperty>PartLookUpDialog,PartDesc,Text,varDescrip
Let>PartStr=Select Products.Code, Products."Desc" From "Products" where (Products.Code Like '%varCode%%percent%') and (Products."Desc" Like '%varDescrip%%percent%')

[armsys]

Try using a variable whose value is "%"

Hi JRL,
Thank you for your solution.

[AndrewT]

That did it.

Thank you JRL!