Please tell me you are not storing credit card numbers. From your description it sounds like you are, and even more scary they may not be encrypted. :w00t:

What is the actual query you are running. This is probably not data related.

Was just about to post almost exactly the same response. 😛 Hopefully that will work.

One thing you should consider. I know this is sample ddl but you should be careful...

Well if it is at all possible you should store your data in proper datatypes. Also the text datatypes is deprecated and will be going away. http://msdn.microsoft.com/en-us/library/ms187993.aspx

Keep in mind that...

I forgot you can't convert from text straight to datetime, I haven't worked with text datatype in quite some time. I assume you are trying to get your data stored...

You mentioned "REPLACE" about 10 times in your post. You can use nested replace like this.

SELECT replace(replace(replace(replace(replace(replace(replace(replace('/ACLNSTUWX', '/', 'L'), 'C', '0'), 'N', '0'), 'S', '0'), 'T', '0'), 'U', '0'), 'W',...

If you really want some help with this issue please read the first link in my signature for best practices on asking questions.

joe.cahoon (3/19/2012)

---

Hello,

I am trying to convert a text field to a VARCHAR, which is not the problem, but I want to than convert the new VARchar column to datetime.

I keep...

njdevils39 (3/19/2012)

---

-Say From_PAY_Rate on March 1st would say 3.00 just to give in example

-Say To_Pay_Rate on latest date as it is shown in the XML file is 3.20 for example...

I have suggested multiple times that the best way is to provide some details so people can help you. You seem to be unwilling to actually take 5 minutes of...

njdevils39 (3/19/2012)

---

I apologize Sean,

but can you please give me an idea or code example how you would go about writing this stored procedure:

Note: Please include emp_name, emp_organization and emp_department from...

I take it you did not bother to read the article I pointed you to. You still have not...

The first example explains quite easily how to convert your xml into a table. Not sure what else you are missing.

The reason nobody has responded to this thread is you haven't provided enough details to even begin to help. The explanation you provided is incredibly vague and their is no...

As noted above this is a duplicate post. Please direct all replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx