You bet... and to confirm, yes, CHAR(9) is the tab character.  You might be able to simplify things if you used the tabl character as a delimiter in the import...

Yep... that too.  For the record, there is no TRIM function in SQL Server 7 or 2000... just LTRIM and RTRIM.  Dunno about 2005.

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...