maureen,

You might want to look here. Just keep your semicolon in the excel spreadsheet, but then split the words apart with one of the several excellent methods mentioned there.

If you want the physical database files:

select [Logical Name] = [name],

[Physical Name] = physical_name

from sys.database_files

if you want the tables and columns...

sandi5980 (7/9/2009)

Paul White (7/9/2009)

Bruce W Cassidy (7/9/2009)

[font="Verdana"]Well, COALESCE is a SQL standard function, not just T-SQL. So perhaps the question is......

GilaMonster (7/9/2009)

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

That's the order...

Lynn Pettis (7/9/2009)

I think :

1. that the first question was definitely fair.

2. the second question is beyond using sql at a fairly basic level, but still a good question (maybe this...

Well, after testing it, I don't know what to say....

Jeff Moden (7/8/2009)

Hi Jeff,

Since the REPLACE function doesn't work on text data types, I think the reason for the cursor was that he was using the UpdateText function. This requires you to...

Great! It's always nice to see the solution that you end up implementing... it...

karthimca07 (7/8/2009)

Tab_Token_Master(Transid,Token_starts_from,Token_Ends_To,Token_value)

Tab_Token_Details(Transid,Token_No,Token_Value,Token_Status)

[p]The first table is used to store the token starting number and end number.[/p]

[p]for example (staring number)1 to 100(ending number). so i have to insert token1,token2...token100...

There are some characters that are "special" to XML; if they are present in the string they will cause the string to not be converted into XML. If you're going...

drewsx2 (7/7/2009)

Thanks for pointing that out... I've edited the post to include the necessary hints...