SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Escape special characters in snippets      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Escape special characters in snippets Author Message gemisigo Joined: 11 Mar 2010 Posts: 2108 Escape special characters in snippets The $ character can be escaped by ^, that is, ^$ wont be interpreted as a variable/macro delimiter. How do I escape the pipe (|) character? Mon Mar 30, 2015 11:18 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 Can you concatenate result of char(124) function instead? Mon Mar 30, 2015 1:11 pm gemisigo Joined: 11 Mar 2010 Posts: 2108 SysOp wrote: Can you concatenate result of char(124) function instead? I was doing that as a workaround, I just thought there must be another way to do that. Not that I'm lazy (I am) but that's 9 character instead of 2 :) Mon Mar 30, 2015 4:57 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.