Query

[EOFR]

Hi Gurus
I am a newbie to DB2 but with a thorough knowledge in SQL, I am just baffled by this.

Let's say that there is a column called NAME from table TAB1. I want to retrieve all records that have embedded spaces from this column (Something like 'Michael Jones' . Here is my query.

Select * from TAB1
where NAME like '% %';

I am getting all the records in the table instead of just a subset with the spaces in between. What am I doing wrong here?

 

[sgursahaney]

Why don't you try the following query:

SELECT * FROM TAB1 WHERE POSSTR(NAME, ' ') <> 0

It should solve your problem.

Regards,
Suresh