Trim the right and keep the Characters of Left

[mohammadkhatimi]

Hi,

I want to trim from right side Month and Year and keep the all the words except month and year in a new field.

Plan for the Month Apr-2015

New field= Plan for the Month

MonthYear= Apr-2015.

Regards,

Mohammad

[prieper]

Have you tried ordinary string-functions already?

RIGHT(YourFieldName, 😎     AS MonthYear

HTH Peter

[robert_mika · Accepted solution]

LEFT('Plan for the Month Apr-2015',LEN('Plan for the Month Apr-2015')-9)

and for month year use Peter suggestion

[mohammadkhatimi]

Thank You...........Robert...........