Re: brain dead?? function to convert char to ascii value, ascii value to char

I think you are going about this the hard way. How about: update table set col = value where lname[1,1] IN ('A','B','C'); Or simply: update table set col = value where lname[1,1] = 'D'; Art S. Kagel kevin_burdish@timeinc.com wrote: > > Hey all! > I have been poring over manuals and I can't seem to find it!!! > I also called tech support he couldn't find it either although it also > seemed familiar to him! > Isn't there a function built in to do the above?? > What I'm trying to do is update a large table with no serial value in small > chunks from a shell script. > > update table set col = something > where FUNCTION IN QUESTION ( lname[1,1]) = 97 (or whatever)> > I seem to remember a built-in fuction that did this, or am I brain dead? > > Please reply to kevin_burdish@timeinc.com as well as the group. > > Thanks, > Kevin