Subject Re: Why won't this sql statement find record when it exists?
Author plinehan
In, "marsh.rolf" <rmmarsh@...> wrote:

> I'm giving up... this is only one user, and I sent him an email
> this am telling him to remove the dashes... no problem he
> replied, so I'm done spending time on this.

You're lucky in that you can tell the end-user to modify
his data.

If you have the source code of the application, you could
put in a trigger to eliminate the dashes before the record
is saved to the database or have a "shadow" column with
the "scrubbed" data for querying and the other data
for display purposes.