Use CHARINDEX instead:
select * from landscapeplan where CHARINDEX(char(13),taxid) > 0
Kurt
>I imported an Excel spreadsheet into SQL and found out that some of the columns have carriage returns in them. I can see them in EM when I browse the table however I cannot see them in QA.
>
>I was trying to come up with a way to remove them but I cannot get the select to work with would return the rows with a CR in.
>
>select * from landscapeplan where taxid like '%char(13)%'
>
>update landscapeplan set taxid = replace(taxid,char(13),'')
>
>Thanks In advance
>
>Quinn