Skip to Content
0
Former Member
Dec 08, 2006 at 04:33 PM

select from table based on lenght of data

924 Views

Hi All,

I have to select from a database table. This table has a field ( field1) in which the data could be either 8 characters long or 10 characters long. I need to select into an internal table only those rows where the data in the field1 is 10 characters long. Please let me know how i can exclude from the selection the 8 character data.

Thanks