Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

need help on select statement...

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

Use LIKE option in WHERE conditions:

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

Max

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

Hi

Use LIKE option in WHERE conditions:

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

Max