Thank You Luis

That is perfect and exactly what I needed, and was trying to do.

I need to brush up on my string manipulations

Thanks again

Andrew SQLDBA

Thank You Everyone

I will try the code sample

Have a great weekend.

Andrew SQLDBA

Thank You to everyone

Jeffery, Special thanks to you. That is exactly what I was in need of.

Hope that you all have a great day.

Andrew SQLDBA

You know, I Never use brackets, unless some fool used a SQL reserved word, or placed a blank space in the object name.

Andrew SQLDBA

Thanks Mister.Magoo

That is it. Perfect.

I feel silly now, I looked in other places in the options, but not there.

Thanks so very much

Andrew SQLDBA

Thanks Joie Andrew

Yes, that was it exactly.

That is just what I deserve for working on a sunday. My mind needs a rest

Thanks

Andrew SQLDBA

I have used Substring, but I could not get it to work if there were a different number of characters. CharIndex takes care of that. And that is the part...

Thank You Lowell

That works perfect. I appreciate the other code to the right wide of the at symbol.

Andrew SQLDBA

Thank You

That was really close, but it was my fault. I don't believe that I was able to describe what I needed, with an exact statement. I was able to...

What type of front-end are you using to connect to SQL Server?

Andrew SQLDBA

Mike

Yes, they are. And everyone should use them. Sprocs can and do accept input parameters and can return data using output parameters. For the ID value form a DropDownList, you...

Why is a developer designing a database? That should be done by a database architect or a SQL DBA.

Andrew SQLDBA

Mike

I am not sure where you got your information about stored procedures (sprocs). They are stored queries, and can do so many things. You can code a trigger to perform...

Mike

Guess where Sharepoint stores the data? You guessed it, SQL Server. You do not need Sharepoint in the middle of things. Use the same database in SQL Server that, if...

Thanks Gail

Greatly appreciate that. Works very nice

Andrew SQLDBA