asked
I have to replace this date 12/28/15 **
I have to remove the ** and have to replace the date can anyone write syntax or query..
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
You should be able to work this out using your other question I just answered [
https://ask.sqlservercentral.com/questions/136192/i-have-to-write-thid-date-to-handle-my-query.html][1] [1]:
https://ask.sqlservercentral.com/questions/136192/i-have-to-write-thid-date-to-handle-my-query.html
It might be better to take a bit of time and formulate a question that describes the underlying problem. For example "I have been given a text file that contains dates in various unpredictable formats and I have been asked to convert them into dates that SQL Server can understand. Here are some examples..." Anyhoo, for this specific post, try this: print convert(date,replace('12/28/15 **',' **',''), 1)
20 People are following this question.
