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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trim , Lpad

Status
Not open for further replies.
ruimgp

ruimgp

IS-IT--Management
Feb 4, 2002
10
0
0
PT
Hi
I want to select trim or lpad some values of integer type
I do select trim(field) or select lpad(field, 10, " ") and i
come up an error.

Can somebody hep me with this sintax?
thank u
 
Sort by date Sort by votes
Not sure but I think clip(field) might do it, apologies if wrong
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davehill1974
  • Locked
  • Question
TRIM Function
Replies
0
Views
21
davehill1974
davehill1974
davehill1974
  • Locked
  • Question
4gl help with trim function 1
Replies
1
Views
61
PHV
PHV
gkrenton
  • Locked
  • Question
Trimming Field
Replies
2
Views
17
gkrenton
gkrenton

Part and Inventory Search

Sponsor

Back
Top