Date: 01/29/07 (SQL Server)    Keywords: sql

I would like to trim off everything past a certain point in a return left. Example Return: This is my information
Desired Return: information

This works just fine and dandy in Crystal but I know instr doesnt work in SQL how can I convert/overcome this hurdle

Example in crystal:
Right("information", (Len("Information")) - (InStr(1,"information", ' ' )))

Thanks for any help...

Source: http://community.livejournal.com/sqlserver/55892.html