Home » Developer & Programmer » Reports & Discoverer » SQL - spaces in cols.
SQL - spaces in cols. [message #391395] Thu, 12 March 2009 02:02 Go to next message
Maverick27
Messages: 84
Registered: October 2008
Member
Can somebody pls. remind the syntax for removing spaces in column when joining SQLs.

I suspect that it definitely the issue of space for the discrepancy in the SQL statements as per attachment.

So when i am joining 2 matching columns from tables i want to get the correct result.

Mave
  • Attachment: sql.jpg
    (Size: 29.70KB, Downloaded 124 times)
Re: SQL - spaces in cols. [message #391399 is a reply to message #391395] Thu, 12 March 2009 02:20 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but I didn't understand the question, nor the image. What "space" are you talking about?
icon11.gif  Re: SQL - spaces in cols. [message #391456 is a reply to message #391395] Thu, 12 March 2009 05:29 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
use RTRIM() function to remove the spaces...

Regards,
Azam Khan
Re: SQL - spaces in cols. [message #391458 is a reply to message #391399] Thu, 12 March 2009 05:30 Go to previous messageGo to next message
Maverick27
Messages: 84
Registered: October 2008
Member
Littlefoot wrote on Thu, 12 March 2009 02:20
I'm sorry, but I didn't understand the question, nor the image. What "space" are you talking about?


No worries Big Foot >> use of RTRIM to removes spaces

MAve
Re: SQL - spaces in cols. [message #391510 is a reply to message #391458] Thu, 12 March 2009 07:27 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, if you say so. I must be quite stupid for not seeing something so obvious to the others.
Re: SQL - spaces in cols. [message #394680 is a reply to message #391395] Sun, 29 March 2009 13:50 Go to previous message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
Hai by using like operation only you can fetch teh values only

see this syntax:
select column_name from table where name like 'Value%' or'%value' 
uyou can use only with % symbole, but you can not use any value without % and ' ' like tis
Previous Topic: 'Error Suppression' in Oracle Report Builder
Next Topic: Passing value across worksheets is possible ?
Goto Forum:
  


Current Time: Tue Dec 06 06:32:15 CST 2016

Total time taken to generate the page: 0.17910 seconds