Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

need help on select statement...

Go to solution
Former Member

‎2008 Sep 15 4:12 PM

0 Likes
429

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
Read only

Go to solution
Former Member

‎2008 Sep 15 4:14 PM

0 Likes
396

Hi

Use LIKE option in WHERE conditions:

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

Max

2 REPLIES 2
Read only

Go to solution
Former Member

‎2008 Sep 15 4:13 PM

0 Likes
396

Use LIKE. Please see F1 on this.

Rob

(changed CP to LIKE)

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

Read only

Go to solution
Former Member

‎2008 Sep 15 4:14 PM

0 Likes
397

Hi

Use LIKE option in WHERE conditions:

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

Max