Home Forums SQL Server 2005 Development Using MAX and LTRIM, RTRIM together RE: Using MAX and LTRIM, RTRIM together
Supriya.S
Ten Centuries
Points: 1131
More actions
November 24, 2009 at 2:45 pm
#1083693
Slick84 (11/24/2009)I get all zeroes. CHARINDEX(CHAR(9), ItemNo, 0)Btw.. do I change the 9?
Slick84 (11/24/2009)
CHARINDEX(CHAR(9), ItemNo, 0)
Btw.. do I change the 9?
Is "ItemNo" the right column name? Just wanted to make sure. 🙂