Re: Does somebody know a better way

From: Noodles <noodles_at_aol.com>
Date: 18 Oct 2002 11:30:34 GMT
Message-ID: <20021018073034.15182.00002161@mb-fy.aol.com>

Chris,

Is this for an OLTP system?

I can't help but think using the client to remove the bad chars BEFORE getting in the database would be easier and solve the systemic problem of non-alpha numeric chars. This might be a classic case of GIGO and the database being expected to exclude all of the user's garbage.

Obviously your DB has all of the excess baggage of these chars that you possibly wont ever want and it's sort of like logical fragmentation with a possibly poor data density.

BUT,... this might not be feasible in your specific situation.

Running a SQL solution with a translate function might not reach your performance requirements. Maybe the TRUE SQL gurus on here have a better solution...

Sometimes the solution is process-based and not code-based.

My 2 cents,
Cliff Received on Fri Oct 18 2002 - 06:30:34 CDT