Select everything starting with first char

[Former Member]

Hi,

I have a simple question and forgot how to do this. I need to do a select statement and select everything from the table for a field i.e. WERKS starting with 'D'. Any help would be greatly appreciated and rewarded.

Thanks,

-David.

[Former Member]

Hi,

I have a simple question and forgot how to do this. I need to do a select statement and select everything from the table for a field i.e. WERKS starting with 'D'. Any help would be greatly appreciated and rewarded.

Thanks,

-David.

[Former Member]

WHERE WERKS LIKE 'D%'.

Thanks,

Srinivas

[Former Member]

thanks Srinivas for quick reply. Its working fo me , have a good day.

[Former Member]

If you simply put your cursor on a SELECT statement and press F!, you'll get your answer very quickly.

Rob