Home » RDBMS Server » Server Administration » how to remove blanks between two columns in SELECT statement
how to remove blanks between two columns in SELECT statement [message #373060] Sun, 25 March 2001 04:46 Go to next message
Narendra
Messages: 10
Registered: March 2001
Junior Member
i want to remove blank space between two
columns generated by SELECT statement in SQL.
is there any method by setting any variable value.
any suggestion....
Re: how to remove blanks between two columns in SELECT statement [message #373064 is a reply to message #373060] Sun, 25 March 2001 22:49 Go to previous message
Thirumalai and Prakash
Messages: 23
Registered: March 2001
Junior Member
Hi Mr.Narendra,

You can include a || symbol between columns in the SELECT list.

Example

SELECT ename || sal || hiredate from EMP;

Hope it helps !
Regards
S.Thirumalai
Previous Topic: How to store image file into long raw column and...
Next Topic: how to remove DDL lock from a table
Goto Forum:
  


Current Time: Mon Dec 23 06:19:10 CST 2024