select statement

[Former Member]

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]

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]

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]

select TCTLOW from TABLE1 into table IT_EMP

where TCTUSERNM LIKE 'N%'.

[Former Member]

This will work -

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

Thanks,

Sheel

[Former Member]

Thank you very much guys.