Re: Changing two letters in a column, is there an easier SQL way?

In article <3p0f42$dkb@miso.wwa.com> john@miso.wwa.com "pinoy_ako" writes: > We have to change two letters in the gear field specifically the > letters "SB" to "SD". The problem is that the position of the > letters are different. These are some of the possible formats: Have you looked at using isqlperl, the version of Perl that speaks to Informix? It's ideal for this sort of thing (and also ideal for solving the kinds of problems people have been talking about here lately with loading data from text files). -- ======================================================== Simon Bunce simonb@misslink.demon.co.uk SHL Learning Technologies +44 (0)171 415 9900 ========================================================