topic select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 30 Apr 2008 16:25:09 GMT

hi all,

Is the following statement correct

select TCTLOW from TABLE1 into table IT_EMP

where TCTUSERNM = 'N*'.

to select all the users starting with N.

thanks.

Former Member — Wed, 30 Apr 2008 16:29:16 GMT

select TCTLOW from TABLE1 into table IT_EMP

where TCTUSERNM like 'N%'.

<REMOVED BY MODERATOR>

Thanks.

Imran.

Edited by: Alvaro Tejada Galindo on Apr 30, 2008 12:30 PM

Former Member — Wed, 30 Apr 2008 16:30:05 GMT

select TCTLOW from TABLE1 into table IT_EMP

where TCTUSERNM LIKE 'N%'.

Former Member — Wed, 30 Apr 2008 16:32:24 GMT

This will work -

select * from tablename where field like 'N%'.

Thanks,

Sheel

Former Member — Wed, 30 Apr 2008 17:32:01 GMT

Thank you very much guys.