Nicely done.  Obviously, we can't get away from a looping structure but this eliminates the cursor that so many dislike and has a couple of tricks in it that you...

Yep, you're right on the setting of the variable... but hopefully every one realizes that was just to demo.  The rest shouldn't be a problem as I used fixed formats...

I like "simple" when I can get away with it ... here's my take on the date part thingy...

--===== Create a...

By using some "JBM PFM"... this is actually a programable converter in that you can program the number of significant digits just by changing the contents of a single variable......

You can find out if they are spaces or characters that look like spaces (assuming that all the rows for a given column have leading spaces)...

SELECT ACSII(LEFT(columnname,1))

FROM yourtable

If the come...

For that query, we will need a calendar table with a search condition like...

Senthil,

Joe is absolutely correct about...

Using Noeld's example, the EXEC statement might look like this...

EXEC (@str1+@Str2)

Yeah... I know about xp_executeSQL...

Ok... let's hope Business Objects has a cross-tab function

 If it doesn't, post back 'cause...

I guess that means you may have more or less than the 4 parts you mentioned in your first post, eh?

Ok... let's hope Business Objects has a cross-tab function (or not,...

Thanks for the compliment but I'm no God of SQL ... even after 11 years with SQL Server, I still make some really...

Dionisis,

I'd say your function has a bit of a bug in it...

SELECT dbo.fn_GetNumber('123-456')

It choked on that pretty hard, I'd say.  The problem is that ISNUMERIC allows the "+", "-",...

>>Thank you for your input. parse name does not work because the values are not as concistent as we want to have

Ummm... post some real data and let us...

If I may make an additional suggestion... it is not necessary to store the data in a Duration column... you could simply make a calculated column consisting of the the...

Steven,

See the post that "SQL Junky" directed you to... the bottom line is ISNUMERIC is not an ISALLDIGITS function... ISNUMERIC allows all sorts of "garbage" in...

Your CASE statement should be...