OP (Ted Montoya) wrote 9/26/2007 10:04 PM that datatype is DECIMAL(5, 4).

All values I tested my code with works...

Do you have an example?

SELECT SUM(Col1), COUNT(Col1), COUNT(*) FROM Table1

WHERE Col2 = 'qwerty'

Thank you!

DECLARE@original DECIMAL(10, 5)

SET@original = 1078.734

SELECT@original,

REPLACE(REPLACE(REPLACE(RTRIM(REPLACE(REPLACE(STR(@Original, 15, 5), ' ', '#'), '0', ' ')), ' ', '0'), '#', ''), '.', '')

Here is a starter how to remove tags in a text

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90034

COUNT needs to scan the whole table.

Try this!

IF EXISTS (SELECT * FROM Performance.dbo.gChangedCUSIPs WHERE CUSIPKey = @vchVAGK + @vchPAC)

SET @bLookForChangedCUSIPs = 1

ELSE

SET @bLookForChangedCUSIPs = 0

Or you can use this, with space instead of backslash

http://weblogs.sqlteam.com/peterl/archive/2007/09/27/Clever-way-to-get-the-records-you-want-with-certain.aspx

Answered here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90392

Lowell's suggestion will work as long as there are only two levels of accounts.

This will traverse complete tree hierarchy

-- Prepare sample data

DECLARE @Accounts TABLE (AccountNumber CHAR(11), ParentAccountNumber CHAR(11))

INSERT @Accounts

SELECT...

Change your TEXT parameter to the new VARCHAR(max).

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89941

Read about "CAST & CONVERT" in Books Online.

SELECTlb.Uid2,

lb.InvalidFlag

FROMtb_LeadBox AS lb

INNER JOINtb_DncNat AS dn ON dn.Dnc_Phone = lb.HomePhone

LEFT JOINtb_LB_SourceCode AS lbsc ON lbsc.SourceCode = lb.SourceCode

AND lbsc.Nat_DNC = 1

WHERElb.InvalidFlag IN (0, 7)

AND lbsc.SourceCode IS NULL

I think he mean TOTAL length for all 8 nvarchar columns.

SELECT TOP 1 WITH TIES PkCol, cl

FROM (

SELECT PkCol, DATALENGTH(Col1) + DATALENGTH(Col2) + DATALENGTH(Col3) + DATALENGTH(Col4) + DATALENGTH(Col5) + DATALENGTH(Col6)...