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 Chris Miller 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
326
zqisme
zqisme
GuptaSteveL
  • Locked
  • Helpful tip
M!Table for extra Gupta SQLWindows Table functionality
Replies
0
Views
205
GuptaSteveL
GuptaSteveL
GuptaSteve
  • Locked
  • Question
Sql Error No Sql cursors remaining - A SQL Handle Class you can use
Replies
0
Views
129
GuptaSteve
GuptaSteve
GuptaSteve
  • Locked
  • Helpful tip
Gupta SQL Handles class
Replies
0
Views
132
GuptaSteve
GuptaSteve
ldoodle
  • Locked
  • Question
OR in StrIFF 1
Replies
2
Views
260
GuptaSteve
GuptaSteve

Part and Inventory Search

Sponsor

Back
Top