Use of left in a query

#1 (**permalink**) 18-Nov-2005, 13:59 PM

If I want to use left e.g., left(len([AssignNo]),4) for Assignment# 123456
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7653-use-of-left-in-a-query.html
would get 1234 what if the user entered 123 it returns a null so how so take
care of that?

*

#2 (**permalink**) 18-Nov-2005, 13:59 PM

JOM,
IF(Len(AssignNo) < 4, [AssignNo], Left([AssignNo], 4))
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"JOM" wrote in message
news:9D28BC01-84A5-4582-B44C-E20DEDE078CE@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7653
> take
> care of that?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7653

#3 (**permalink**) 18-Nov-2005, 13:59 PM

If you use left 4 on 123 it should return 123

The problem is with the left that you gave us
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7653
left(len([AssignNo]),4)

Should be without the len
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7653

left([AssignNo],4)
--
I hope that helped
Good Luck

"JOM" wrote:

> 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?