|
View previous topic :: View next topic
|
| Author |
Message |
nidhimishra_8
New User
.jpg)
Joined: 26 Nov 2008
Posts: 5
Location: Bangalore
|
|
|
|
I am running the following SQL query
SELECT DISTINCT ABC FROM
S#MNO.Table1
WHERE
ABC LIKE '%XYZ'
And no data is extracted.
But when i am running
SELECT DISTINCT ABC FROM
S#MNO.Table1
and serach XYZ in it, i find many entries.
I dont know what the problem is, the query is correct only.  |
|
| Back to top |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
| Your first query is for findind all ABC which ends with XYZ .... if you have entries in table please use RTRIM(ABC) like '%XYZ' because spaces might be there after XYZ .... if not check whether your entries in your second query actually ends with XYZ ... |
|
| Back to top |
|
|
Amsar
New User
.jpg)
Joined: 26 Sep 2008
Posts: 84
Location: Chennai
|
|
|
|
Nidhi,
In query
| Quote: |
SELECT DISTINCT ABC FROM
S#MNO.Table1
WHERE
ABC LIKE '%XYZ' |
Make sure that string 'XYZ' in the table is in uppercase format ,
If its is in lowercase format in table your query will not fetch any values.
Regards,
Amsar |
|
| Back to top |
|
|
vishalbshah
New User
Joined: 01 Dec 2006
Posts: 61
Location: Pune
|
|
|
|
Hi Ashimer,
By chance do you know whether using RTRIM would stop DB2 from using the column as index if that is available for that colum? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
vishalbshah,
why would you ask someone,
that last posted to this thread 3 years ago,
(who incidentally has not posted a message in over a year)
who provided the incorrect answer to the question in this thread
a question,
that is being answered by GuyC in your other thread.
Personnally, if I had to ask someone other than GuyC a db2 question,
I would only ask someone like Craig Mullins
(who probably would not respond anyway to such a basic question as yours). |
|
| Back to top |
|
|
|
|
