Solved

In T-SQL Sybase, how will you replace linefeed, chr(10), with space while querying from a table column?

Posted on 2008-06-16
6
4,200 Views
Last Modified: 2013-12-27
select replace(<column name>,chr(10),'') from dbo.<table name>

The query above does not work, "Incorrect syntax near keyword, 'replace'

I'm unable to import the row because the column data contains line feed.
0
Comment
Question by:villavej
6 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 21794213
"replace" is a reserved word in Sybase T-SQL. Try exactly the same syntax, just call it str_replace instead:

     select str_replace(<column name>,chr(10),'') from dbo.<table name>
0
 

Author Comment

by:villavej
ID: 21794241
Error: Function 'chr' not found.
0
 

Expert Comment

by:TahirKhalil
ID: 21794255
Assuming you have only 1 linefeed per value, you can use stuff+charindex as replace function:

declare @x char(35)
select @x="Test"+char(10)+"String"
select stuff(@x,charindex(char(10),@x),1,'*')

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 250 total points
ID: 21794372
Oh, I didn't even notice the "chr". Yeah. Make that "char(10)". 8-)
0
 

Author Closing Comment

by:villavej
ID: 31467605
Thanks, it's working now.
0
 

Expert Comment

by:dougsur
ID: 22723544
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OpenLDAP Proxy to Active Directy 6 385
Can I delete authorized_keys in FreeBSD 1 99
Expand a partition in Centos 7 Linux with Virtualmin 1 69
UNIX SCP 5 83
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question