SQL question Syntax problem maybe?

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