check the field contains alphabets or - or alphanumeric
796062Oct 26 2010 — edited Oct 26 2010I have a cursor which returns one filed data into the result.
I have to check whether the data contains '-'(hyphan) then want to assign something else
if the data contains alphabetics then want to assign something
else want to assigh something.
ex: Cursor cur_test select field1 from table1.
Please help.
thanks!!!