|
View previous topic :: View next topic
|
| Author |
Message |
PrabakarV
New User
.jpg)
Joined: 21 Dec 2007
Posts: 88
Location: My Desk
|
|
|
|
| the column length is 30 bytes. I want to select it as 40 byte field using query. is it possible to select in a way like i said above... i tried with substr... but it could not go beyond 30 bytes.... |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| please re-read your post. if it makes any sense to you then I am very confused. |
|
| Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Prabakar,
Did you try using CONCAT.
Eg:-
| Quote: |
| CONCAT(column,'spacesspaces') |
Thank You,
Sushanth |
|
| Back to top |
|
|
PrabakarV
New User
Joined: 21 Dec 2007
Posts: 88
Location: My Desk
|
|
|
|
thank u very much Sushanth... it works  |
|
| Back to top |
|
|
|
|
