Hi all, This is a plain simple sql question appologies for posting it here. Am looking for a way of combining values from several fields(and introducting value separators). select field2+"_"+field1 from tableA; I've tried select field2||'_'||field1 from tableA; I get "1" as the result(which is not what I want). Allan. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
