topic Re: need help on select statement... in Application Development and Automation Discussions

need help on select statement...

Former Member — Mon, 15 Sep 2008 15:12:13 GMT

Hi,

I need to fetch from vbfa table those records where vbeln starts with '0800'.

my select statement given below gives a syntax error..pl help.

SELECT * FROM vbfa WHERE vbeln(4) = '0800'.

vbeln(4) is not accepted and i get the message ' field vbeln(4) is unknown' ...what to do?

thks

Former Member — Mon, 15 Sep 2008 15:13:34 GMT

Use LIKE. Please see F1 on this.

Rob

(changed CP to LIKE)

Edited by: Rob Burbank on Sep 15, 2008 11:18 AM

Former Member — Mon, 15 Sep 2008 15:14:39 GMT

Use LIKE option in WHERE conditions:

SELECT * FROM vbfa WHERE vbeln LIKE '0800%'.

Max