Find asterisk (2000/XP)

Topic

New Reply

I have some text (in multiple fields) that contains a leading asterisk( *).
I’m trying to write a function I can use in an update query.

How do I check for the asterisk rather than vba assuming I’m using it as a wild card.

The data (which is messy) was imported as fixed width, with all fields as text (due to characters such as * and 3 dashes to indicate no data).

This means I have lots of spaces I need to trim off. Before I can us trim I need to get rid of the *’s

Reply | Quote

Replies

To search for an asterisk as a character, use [*] in the Find what box. Similarly, to search for a question mark, use [?]

Reply | Quote

You can use the InStr() function to look for the character. A value >0 indicates it is in string.

Reply | Quote

Thankyou.

I’d managed to find in Excel you use a ~ but couldn’t find what to do in Access. Quite surprised I’ve never needed to do this before.

Reply | Quote