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...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"David" <da***@scene-double.co.uk> wrote in message
news:c1**************************@posting.google.c om...
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