Professional Web Applications Themes

Question on REPLACE - Microsoft SQL / MS SQL Server

I have the following codes: select count(abc) from table1 a where replace ('a.a_date>=''2002-01-01'' and a.a_date<=''2002-12- 31''','a_date','b_date') Then I get an error message saying "Incorrect syntax near ')'". What is the right way to do the replacement? Due to more complicated conditions behind-the-scene,can't just retype the new column name. Thank you in advance for the answer....

  1. #1

    Default Question on REPLACE

    I have the following codes:

    select count(abc) from table1 a where replace
    ('a.a_date>=''2002-01-01'' and a.a_date<=''2002-12-
    31''','a_date','b_date')

    Then I get an error message saying "Incorrect syntax
    near ')'". What is the right way to do the replacement?
    Due to more complicated conditions behind-the-scene,can't
    just retype the new column name.

    Thank you in advance for the answer.
    Jane Guest

  2. #2

    Default Re: Question on REPLACE

    replace() is used to change literal strings (period). You cannot use it like
    that in the Where clause. You have to specify all your filters to comply.

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Jane" <com> wrote in message
    news:029701c35c4f$d8040620$gbl... 


    oj Guest

  3. #3

    Default Re: Question on REPLACE



    UPDATE table1
    SET a_date=b_date
    WHERE a_date BETWEEN '20020101' and '20021231'

    "Jane" <com> wrote in message
    news:029701c35c4f$d8040620$gbl... 


    Nikhil Guest

Similar Threads

  1. Nybie question consering char replace
    By Esko Piirainen in forum PHP Development
    Replies: 1
    Last Post: August 28th, 11:00 PM
  2. find/replace question
    By Ian_Jacobs@adobeforums.com in forum Adobe Indesign Windows
    Replies: 6
    Last Post: August 11th, 05:54 AM
  3. Search and replace (super global replace)
    By johnweiffenbach@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: April 8th, 08:56 AM
  4. Search and Replace Question
    By DareDevil in forum Macromedia Dreamweaver
    Replies: 6
    Last Post: December 11th, 06:19 PM
  5. Replace Question
    By Redcat in forum PHP Development
    Replies: 6
    Last Post: November 7th, 04:19 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139