RE: Using MATCHES or LIKE on non-character columns ?
select emp_no
from table
where emp_no || "" matches "12*"
-----Original Message-----
From: Bernd Steinhauer [mailto:bernd.steinhauer@dpd.de]
Sent: Monday, February 12, 2001 11:23 AM
Posted To: informix
Conversation: Using MATCHES or LIKE on non-character columns ?
Subject: Using MATCHES or LIKE on non-character columns ?
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
********************************************************