Skip to Content
0
Feb 24, 2009 at 01:50 PM

Functions in SQL query

41 Views

Hello Xperts,

I need to write a select query which will give me the length of the string value stored in the field.

At present I have to read all values from the table and then loop at each value into workarea to find length of each field.

Is there any alternative to this? I am querying a table with more than 300K records and I do not want to loop at 300K records to find the desired field.

Any help is highly appreciated.

Ashutosh