Building SQL Statement with Like Clause

[jtrembla]

 strSQL = "SELECT ULTIMATE_DUNS FROM T_DB_MATCH" _
            & " WHERE (SPONS_DFE_NAME) Like '" & strCompany & "*'" _
            & " GROUP BY ULTIMATE_DUNS"

the code above returns 0 records. However, if I debug.print strSQL and paste the output into the query window I get results. Is the problem with the Like function?

 

[Eupher]

Total guess, here, because your concatenation and syntax look correct - but maybe try adding the asterisk to the string variable before concatenating it in your SQL string? i.e.:

strCompany = strCompany & "*"

strSQL = "SELECT ULTIMATE_DUNS FROM T_DB_MATCH" _
            & " WHERE (SPONS_DFE_NAME) Like '" & strCompany & "'" _
            & " GROUP BY ULTIMATE_DUNS"

HTH,

Ken S.

 

[HarleyQuinn]

How are you executing the query?

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

the code above returns 0 records
the code above simply set a variable value and thus I don't understand why you're expecting some records to be returned ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886