need help on select statement...

[Former Member]

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]

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]

Hi

Use LIKE option in WHERE conditions:

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

Max