How do I select part of a text string?

[lathow]

I'm new here. Trying to use Informix. How do I create a Select statement that selects rows by the last 3 characters of a text string in one of the columns? The VB statement would be RIGHT(text,3).

[Anon]

select from <table_name> where <column_name> matches "ABC";

Check out more Informix SQL by downloading the manual for your version at http://www.informix.com/answers/english/alpha.htm

Hank