Toad World® Forums

char_length

I’m trying to filter out some rows that do not have correct tracking numbers. The tracking numbers should be 15 characters long. I want to filter out the ones that are only 10 chars. Any ideas? Thanks!!!

Hi Christopher,

We assume that what you asked for is having the filter in the data grid to provide you an option to filter the rows.
We don’t have that option yet in the current release of SQL Navigator.

I would like to check if it would work for you to use Oracle function "LENGTH() " to filter out the rows as per your requirement:

select * from table_name
where length(tracking_number)<>10;

Thanks and best regards,
Shirly