Rick Hillegas <[EMAIL PROTECTED]> writes: > Hi Albert, > > As Dyre and Donald point out, the LIKE operator can only be applied to > strings. You can write your own casting function to turn your integers > into strings (or to extract other information which you may be > encoding in integers). Something like the following should work: > > select * from t > where intToString( intCol ) like '34%'
We also have a built-in function called CHAR that does this: http://db.apache.org/derby/docs/dev/ref/rrefbuiltchar.html -- Knut Anders
