Searching for "*" in record

[drichter12]

Is it possible to search for an asterisk in a record field? The records I am searching for are any record where the "Site Name" field contains an asterisk as the first charachter of the name. To make it easier, there will be no asterisk in this field that is not in the first character position so technically I am just searching for the occurance of and asterisk in this field.

Thanks,

Dale

 

[PHV]

One way:
SELECT *
FROM yourTable
WHERE [Site Name] LIKE '*[*]*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[drichter12]

Well, that was simple.... Thanks, it works as requested.


Dale

 

[lameid]

Where [Site Name] Like "*[*]*"

Note the square brackets specify a character list that must be in a postion.

See Access help "Using Wildcard Characters in String Comparisons" for more detailed information.

 

[lameid]

I guess I should refresh if I don't answer right away....