Macgyver7 <t...@buffaloriverforge.com> wrote: > I tried the case function that was recommended, but that seems to recognise > everything in the column as text
This means that everything in the column is in fact text. You do realize that '123' is not the same thing as 123, right? > except when it encounters a NULL. I > changed the column type to varchar, but that made no difference. What difference did you expect? > select (case when typeof (translit) = 'text' then translit else "@" end) > from otpfinal; > > This was a test to see if it would recognise numbers and replace them with > an @. It only replaced NULL fields. If by "number" you mean "a string that consists only of digits", you could try a test like ltrim(translit, '0123456789') = '' -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users