Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strip White Space Character In SQL

Status
Not open for further replies.
playah

playah

Programmer
Oct 27, 2008
1
NL
Hi,

Is it possible to execute a SQL query that removes the spaces from a text?

for example I have a value '123 131 123 121' and I would like to have '123131123121' returned.

In SqL serve I can use the replace function, but this does not work the same way in SQLBase?

 
Status
Not open for further replies.

Similar threads

zqisme
  • Locked
  • Question
SQL Base Error Code 9268 for Gupta SQL 1
Replies
0
Views
244
zqisme
zqisme
GuptaSteveL
  • Locked
  • Helpful tip
M!Table for extra Gupta SQLWindows Table functionality
Replies
0
Views
158
GuptaSteveL
GuptaSteveL
GuptaSteve
  • Locked
  • Question
Sql Error No Sql cursors remaining - A SQL Handle Class you can use
Replies
0
Views
94
GuptaSteve
GuptaSteve
GuptaSteve
  • Locked
  • Helpful tip
Gupta SQL Handles class
Replies
0
Views
97
GuptaSteve
GuptaSteve
ldoodle
  • Locked
  • Question
OR in StrIFF 1
Replies
2
Views
184
GuptaSteve
GuptaSteve

Part and Inventory Search

Sponsor

Back
Top