DB2 query !!

[pradeepshan]

how will you select a rec from a table having a name with 'c' starts in the second position?

eg:mclaran

Table contain Empname, empno,city

also if suppose the name is '_caterina' how will you get it?

[Guest]

select from <list of columns to be selected>
from <table name>
where name like '_c%';

[lucky.rohith]

select empname, city from emp where empname = '-c%'

[156138]

Select (colums whichever you want)
INTO(.......)
FROM table name A
WHERE A.name LIKE '_C%'
_________________
Regards,
Vinod Reddy.