InStr used in SQL query
Thanks. That's what I need.
On Fri, 18 Jul 2003 23:18:57 +0100, Mike NG
wrote:
On Fri, 18 Jul 2003 at 02:50:55, dchow (dchow )
wrote:
WHERE (InStr(TaxID, ""PST"") < 0)
If I changed it to
WHERE (Right(TaxID, 3) = ""PST"")
Change your SQL to
WHERE TaxId LIKE '%PST%'
Well that's what standard SQL is anyway. If that doesn't work, then it
may be * instead of % - I say this because the Like keyword in an If
statements expects *
e.g. If TaxId like '*PST*' Then
|