topic Select everything starting with first char in Application Development and Automation Discussions

Select everything starting with first char

Former Member — Fri, 26 Oct 2007 20:57:43 GMT

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.

Re: Select everything starting with first char

Former Member — Fri, 26 Oct 2007 20:58:47 GMT

WHERE WERKS LIKE 'D%'.

Thanks,

Srinivas

Re: Select everything starting with first char

Former Member — Fri, 26 Oct 2007 21:02:12 GMT

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

Rob

Re: Select everything starting with first char

Former Member — Fri, 26 Oct 2007 21:03:53 GMT

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