09-15-2008 4:12 PM
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
09-15-2008 4:14 PM
Hi
Use LIKE option in WHERE conditions:
SELECT * FROM vbfa WHERE vbeln LIKE '0800%'.
Max
09-15-2008 4:13 PM
Use LIKE. Please see F1 on this.
Rob
(changed CP to LIKE)
Edited by: Rob Burbank on Sep 15, 2008 11:18 AM
09-15-2008 4:14 PM
Hi
Use LIKE option in WHERE conditions:
SELECT * FROM vbfa WHERE vbeln LIKE '0800%'.
Max