Use of left in a query

J

JOM

If I want to use left e.g., left(len([AssignNo]),4) for Assignment# 123456
would get 1234 what if the user entered 123 it returns a null so how so take
care of that?
 
O

Ofer

If you use left 4 on 123 it should return 123

The problem is with the left that you gave us
left(len([AssignNo]),4)

Should be without the len

left([AssignNo],4)
 
Top