Hey guys,

I am creating a query that will return all member names where their first name contains a single character.

I can't find any db2 functions that will work for me. I can accomplish this in SQL with "where DATA_LENGTH(FNAME) = 1", but I can't find a DB2 equivalent to this function.

The string functions don't seem to work because they would be looking for specific values. Can anyone help?

Thanks!

I just found the solution:

where LENGTH(RTRIM(NAME)) = 1

At least up to the SQL standard 2003, DATA_LENGTH is not a standardized function. So for more portable code, you shouldn't rely on it in other database systems either.

where length(replace(FNAME,' ','') = 1
or
where length(strip(FNAME,B,' ') = 1

will preclude your overlooking FNAMEs that start with a space and then a character.