How can we help you today? How can we help you today?

Snippet not working for paranthesis

I am trying to use this code for a snippet

UPDATE table SET column = REPLACE(column,' ', ' ')

but when i try to run this snippet its missing the paranthesis like this

UPDATE table SET column = REPLACEcolumn,' ', ' '

Can someone help me out how to get the paranthesis in my final result by using snippents. Thank You.
kiranreddy
0

Comments

2 comments

Sort by
  • ChrisRickard
    Surround the Parens with braces:

    UPDATE table SET column = REPLACE{(}column,' ', ' '{)}

    http://www.red-gate.com/help/sqlprompt/Topics/SPT_ConfigAutoInsert.html
    ChrisRickard
    0
  • Bart Read
    Hi Kiran,


    Thanks for reporting this, and thanks again to Chris for the workaround. At this stage it's not clear to me whether this is something that just needs documenting better, or whether we can actually do something to stop you needing to do this. However, we are aware that there is an issue here (you're far from being alone in having problems with this), and will be addressing it in some way for version 3.


    Many thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.