SUBSTRING with a RIGHT function? 1

[AuctionLamb]

Hi guys!!

I have a field(GLCODE) that looks like this "Stationery - 10-00-809-52". I ONLY want to see the "00" in this field, how do I do this?

I know I can do a RIGHT and then a SUBSTRING, but how do I combine it?

THANKS!!!

 

[audiopro]

Does the format of the required field remain constant?


Keith

http://www.studiosoft.co.uk

 

[AuctionLamb]

Yes, the right part of the field is always the "10-00-809-52" part.

 

[jonwolds]

Try

left(right(GLCODE, 9),2)

Jon

 

[AuctionLamb]

THANKS jonwolds!!!

Works great......explain to me how the left and right works in your syntax because I thought it will only take on the right function....

 

[jonwolds]

RIGHT function is actioned first, returning the right nine characters to the LEFT function, which in-turn returns the left 2 characters (of the nine).

Cheers
Jon