Need help with a query to return ASCII characters in table

[dmacman1962]

Hello everyone,

I am trying to identify the ASCII value of some strange characters in my database (these are all in the email address field).

I have not seen any examples of a query the will breakdown the ASCII values of, say the email address field if I use part of the address in the query.

Meaning, if I use 'LIKE '[e-mail]%' for the search, how can I get the ASCII values for each individual character in that query, so I can identify the invalid ones and then replace them?

As always, thanks in advance,

Don

[tomhath]

Use the ASCII() function. Pass it a single character and get back the ascii code. If you pass it a string you get the code of the leftmost character.

select ASCII('A')

[Weedpacket]

Note that the ASCII function is SQL; in PHP it's [man]ord[/man]