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

line feeds and carriage returns

Status
Not open for further replies.
guillermococa

guillermococa

Programmer
Feb 25, 2007
5
ES
Hello
I Have a problem with a field that contains line feeds and carriage returns, and want to drop them, have tried with:

TRIM (TRAILING ' 0D'XC FROM TRIM (TRAILING ' 0A'XC FROM (nombre_campo))

And it doesn't work
 
Status
Not open for further replies.

Similar threads

dechrist
  • Locked
  • Question
Duplicates and Ranking
Replies
0
Views
104
dechrist
dechrist
dorblem
  • Locked
  • Question
TeraJDBC 14.00.00.13] [Error 3706] Syntax error: expected something between '(' and the 'substr' key
Replies
0
Views
88
dorblem
dorblem
abhijeetgupta29nov
  • Locked
  • Question
Help Sql: Please verify solution and let me know if any better to achieve this ....
Replies
0
Views
61
abhijeetgupta29nov
abhijeetgupta29nov
larry609
  • Locked
  • Question
Teradata Field names and DAO/ADO/OLEDB access problem
Replies
0
Views
56
larry609
larry609
Henshin1
  • Locked
  • Question
Tpump and Load failure
Replies
1
Views
74
madanjs
madanjs

Part and Inventory Search

Sponsor

Back
Top