and just cuz no one mentioned it ( not cuz it's better than UPCASE() & DOWNCASE() ),
CONVERT does character for character swapping: CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' in ANYSTR and CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz' in ANYSTR or UPSTR = CONVERT( 'abcdefghijklmnopqrstuvwxyz', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', ANYSTR ) and DNSTR = CONVERT( 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz', ANYSTR ) depending on your mood. Note the difference bstween REPLACE() & CONVERT(). Use REPLACE() to replace an entire substring with another substring. CONVERT does char by char. A common misconception. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
