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]
INTERSECT SQL EXAMPLE
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]