On 9/11/08, Ryan Stille <[EMAIL PROTECTED]> wrote: > > Thank you for the link Darryle, but I don't think you read through my whole > question. I have already read through that page, and I see how to use regex > as a condition for a select. What I am interested in is applying a regex to > a column as I select it. Selecting a varchar column with all the > non-ascii characters removed, for example. > > -Ryan
I'd be curious if you could touch in any way non-printable characters using just SQL queries. A few weeks ago I posted here a question about removing form feed characters from a text column and never received any response. I also did extensive Googling and didn't find any workable solutions using just SQL queries. There were a number of proposed solutions whereby a programming language was used, C/C++ and Perl, IIRC, but I didn't go down that route. FWIW, I did try all manner of using relace() to remove the FF's and nothing worked for me. David
