Using LIKE with IF....

[David]

Hi,

I have a recordset which pulls out specific customer names.
One of our customers have many branches, i.e:
Customer A Site 1
Customer A Site 2
Customer A Site 3
etc.....

I have the following IF statement, and want to catch all of the Customer A names...

If RS("CustomerName") like Customer A * then........

I just want to catch all customer names starting with 'Customer A'.

I'm sure this statement will work, i'm just missing a quote or something ??

Appreciate your help

David

 

[Aaron [SQL Server MVP]]

Why don't you do this IN THE QUERY instead of while processing the results?

You didn't mention what database you're using, but in SQL Server,

SELECT
Customer, site
FROM wherever
WHERE Customer LIKE 'Customer A%'

This reduces the amount of network chatter and lets the engine use an index
instead of returning all the data (often a more expensive table scan).

However, if you insist that you want to do this in ASP, and just throw away
the rest of the rows, then you can't use LIKE. LIKE is a SQL operator, not
present in VBScript.

strLike = "Customer A"
strLen = Len(strLike)
do while not rs.eof
strDB = rs("CustomerName")
if left(lcase(strDB), strLen) = lcase(strLike) then
........
end
rs.movenext
loop

However, I might suggest that your design is flawed, if all 'Customer A%'
are the same customer, then perhaps you should be using a master table and
inserting the ID of the customer instead...

 

[David Gordon]

Aaron,


Cheers,
that did the trick !

Why did'nt I think of something so simple.....Doh !


Great Work


Thanks again.