Wildcards character/syntax

SoC · May 27th, 2005, 01:18 AM

Hi,

I have a little script that is supposed to check for a certain value in a db column, and then do something if that particular calue is present:

Code:

...<%ElseIf rsIDK.Fields.Item("my_column").Value = "/default.asp" then ...

The problem is that my_column can contain up to 300 characters, so the code above doesn't work. What I really need is a wildcard at the end of "/default.asp" but I don't really know the correct way of doing this.

s

ChrisScott · May 27th, 2005, 03:46 AM

Hey s,

Try...

Code:

ElseIf Left(rsIDK.Fields.Item("my_column").Value, 12) = "/default.asp"

HTH,

Chris

SoC · May 27th, 2005, 11:16 PM

Yes, perfect. I see how it works.

Thanks for that.