Len() Function

Posted in 2003

Phillips, Rob — Mon, 12 May 2003 20:48:51 — source: IIUG Forums & Mailing Lists

Is there a way to get the length of a field in informix? Not the max length of a field but the length of the data in a character field? Robert Phillips (rphillips@ce-a.com) Systems Analyst Chamberlin Edmonds and Associates (www.ce-a.com) 404-634-5196 x1261

↪ replying to Phillips, Rob

Garth Davis — Mon, 12 May 2003 21:55:38 — source: IIUG Forums & Mailing Lists

LENGTH() gives the number of characters in a column excluding trailing spaces. -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of Phillips, Rob Sent: Monday, May 12, 2003 3:49 PM To: ids@iiug.org Subject: Len() Function [1115] Is there a way to get the length of a field in informix? Not the max length of a field but the length of the data in a character field? Robert Phillips (rphillips@ce-a.com) Systems Analyst Chamberlin Edmonds and Associates (www.ce-a.com) 404-634-5196 x1261

↪ replying to Phillips, Rob

Patrick McDonough — Mon, 12 May 2003 22:19:19 — source: IIUG Forums & Mailing Lists

Yes, length() Patrick Phillips, Rob wrote: >Is there a way to get the length of a field in informix? Not the max length >of a field but the length of the data in a character field? > >Robert Phillips (rphillips@ce-a.com) >Systems Analyst >Chamberlin Edmonds and Associates (www.ce-a.com) >404-634-5196 x1261 > > > >