Internet »
Cold Fusion »
SQL
SQL LIKE
'A_Z': All string that starts with 'A', another character, and end with 'Z'. For example, 'ABZ' and 'A2Z' would both satisfy the condition, while 'AKKZ' would not (because there are two characters between A and Z instead of one). For example, 'ABCD' and 'ABCABC' would both satisfy the condition. For example, 'LOS ANGELES' and 'SAN FRANCISCO' would both satisfy the condition.
http://www.1keydata.com/sql/sqllike.html [cache]
SQL MINUS WHERE
SQL LIKE
'A_Z': All string that starts with 'A', another character, and end with 'Z'. For example, 'ABZ' and 'A2Z' would both satisfy the condition, while 'AKKZ' would not (because there are two characters between A and Z instead of one). For example, 'ABCD' and 'ABCABC' would both satisfy the condition. For example, 'LOS ANGELES' and 'SAN FRANCISCO' would both satisfy the condition.
http://www.1keydata.com/sql/sqllike.html [cache]