Well, I'm confused with this thread. Why not just this?

select replace(@var, char(10) + char(13), '')

This works on my machine. The string you gave is '1yxyx2yx3yxyx4yx5' where y = char(13) and...

Could it all be permissions related?

BOL (http://technet.microsoft.com/en-us/library/ms186301.aspx)...

"built-in functions such as OBJECT_NAME may return NULL if the user does not have any permission on the object"

Oops - yep I missed the ID :pinch: - glad I could help though 🙂

Chris Morris (4/21/2008)

---

Hi Ryan

Not at all - CAST() is...

This would be a guess in the absence of more information. To put this together, I first focused on getting the data we needed from the COSTS table and in...

The query you will need will be much less complicated than this. If you post your table structure, and some sample data, it will be much easier and quicker for...

Roy Ernest (4/21/2008)

---

I would suggest you to use a Case statement over an OR clause.

SELECT blah

FROM blah

WHERE IsValid = 1

...

Lil Ms Squirrel (4/21/2008)

---

I'm not sure I explained myself properly...

If @SiteNumber = -1 then I want to return all records but if @SiteNumber has a value of one or greater...

select replace(convert(varchar(8), getdate(), 3), '/', '')

Yes. Tricky. Maybe you can do something along these lines...?

select 'start' --needed...

1 or -1? Anyway, here's one way...

SELECT blah FROM blah WHERE IsValid = 1 AND (@SiteNumber = -1 OR SiteNumber = @SiteNumber)

Chris

I don't see any implicit conversion. Are you suggesting that what I posted is implicit?

I feel that we haven't quite pinned your requirements down yet. Maybe the sample data and query here will help...?

declare @t table (TradeRef varchar(32))

insert @t

...

Hi Robert

There are a few reasons. Some people find it...

Duplicate post

http://www.sqlservercentral.com/Forums/Topic487765-169-1.aspx