>I need to obtain the proper syntax to do a query on a character field based on the last four characters. For example, the record could have this value in that field: ThisIsMyFileName.ext. Thus, I need to locate the .ext record.
MyColumn LIKE '%.ext'
--sb--