Skip to Content
0
Former Member
Mar 17, 2009 at 12:02 PM

using left in select

19 Views

i have a field which is combination of two fields.

doctype+year 123452008

12345 2008

i want 12345 only,i use same santax in sql server.but here it makes problem.tell me whats wrong with it.

select single left ( awkey , 5 ) as awkey from bkpf into zmatdoc where belnr = bkpf-belnr .