RE: substring in informix SQL?
Hi Todd,
try
SELECT address FROM customer WHERE client_id[5,10] = "XYZ-someid";
I hope this help,
Irineu
> ----------
> From: Todd Gibson[SMTP:tgibson@flatland.dimensional.com]
> Reply To: Todd Gibson
> Sent: Tuesday, October 20, 1998 2:23 PM
> To: informix-list@iiug.org
> Subject: substring in informix SQL?
>
> Is there any way to get a substring in a SQL expression?
> Something like:
>
> SELECT address FROM customer WHERE client_id => substring('XYZ-someid',5,10);
>
> Thanks,
> -TAG
> Todd A. Gibson
>