Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    2

    Question Unanswered: text replacement

    Hello all,
    I get some dates entered manually in french format in a varchar(255) field and want to convert that field in datetime. Since, Enterprise manager is warning me about a risk to loose information, I'm thinking about a way to update the french text in the corresponding english text before doing the conversion.
    Example:
    25-fév-08 (varchar(255)) has to become 25-feb-08 (datetime)

    Could anybody help me, please?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    There's a lovely function called Replace() which will do what you want.
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2008
    Posts
    2

    Thanks

    Thanks Georgev, your suggestion works fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •