Re: Using MATCHES or LIKE on non-character columns ?

select emp_no from tabname where emp_no||" " like "12%" "Bernd Steinhauer" <bernd.steinhauer@dpd.d To: informix-list@iiug.org e> cc: Sent by: Subject: Using MATCHES or LIKE on non-character owner-informix-list@iiu columns ? g.iiug.org 02/12/01 10:22 AM Please respond to "Bernd Steinhauer" Hello, I need a query that selects all numeric ids that start with the same number. For example I want to select all rows where emp_no starts with 12, but emp_no is a integer field. emp_no ------- 12 123 120003 123434434 Any help would be appreciated ! Thanks in advance -- ******************************************************** DELICom DPD Deutscher Paket Dienst GmbH & Co. KG Wailandtstrasse 1, D-63741 Aschaffenburg Tel.: +49 (0)6021/492-6064 Fax: +49 (0)6021/492-6503 E-Mail: Bernd.Steinhauer@dpd.de Internet:www.dpd.de ******************************************************** ------------------------------------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.