No "Left" function in Expression Builder?

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

DannoCoy wrote:

Anyone know the reaon the Left function was left out of the list of string functions in the Expression Builder?

Danno

No. Annoying isn't it?

Instead you can use REVERSE(RIGHT())

-Jamie

|||I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.|||

DarrenSQLIS wrote:

I think SUBSTRING would be slightly faster for simple operations. You got your nesting the wrong way round as well, but we know what you mean.

Oh you're so picky :)