I figure it out putting double quotes around the whole password.

They both worked. I am developing on SQL 2005 and it does work in 2008.

Thank you

Tim

I am getting error when I run this.

It looks like I am going to have to come up with a different solution.

Thanks for all the replies.

Tim

No, I am not sure how to do that but I have seen that syntax but I was not sure how that worked. Also, the stored procedure...

I did not know that but COALESCE will work for my data. There will always be only one value for the three columns.

I will keep the other example as...

Both examples work great but COALESCE() is simple.

Thank you

and I thought the XPATH stuff was the hard part

Thanks

Tim

I see the issue. It looks like I need to come up something sooner that later.

Thanks Tim

I got it to work using dynamic sql and converting the entire select statement to a string and executing the string.

DECLARE @StartDate datetime

DECLARE @EndDate datetime

SET @StartDate = '01/20/2011'

SET @EndDate =...

I tried declaring the dates as varchars and the query returned records outside of the date range.

I am inheriting this data but I think the values that are beginning inserted into the table are not always guaranteed to be a date and I can't not change...

This is what I needed. I appreciate your help.

Thank you,

Tim

This solution will work. I need to study up on how you did the ID field and figure out the syntax.

Thank you for your time. ...

There will be multiple fields and not always same number of field and not in the same order for each orderdocumentrequest element. But I don't always want every...