Replacing WildCard Character
-
Hi, I want to replace the wildcard character '&'. Actually Entering the & as a input in search criteria gives all records. I want to replace that character so that i won't get any record for that. I am using Oracle as database. Thanks, Umesh Tayade
-
Hi, I want to replace the wildcard character '&'. Actually Entering the & as a input in search criteria gives all records. I want to replace that character so that i won't get any record for that. I am using Oracle as database. Thanks, Umesh Tayade
oracle syntax
replace('My&String', '&', '');C# syntaxstring newString = "My&String".Replace("&","");
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com
-
Hi, I want to replace the wildcard character '&'. Actually Entering the & as a input in search criteria gives all records. I want to replace that character so that i won't get any record for that. I am using Oracle as database. Thanks, Umesh Tayade
Hi, I got the Answer. I Replaced & by ascii value of it(&). Its Working.
-
oracle syntax
replace('My&String', '&', '');C# syntaxstring newString = "My&String".Replace("&","");
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com
Hi, Thanks for Answering, but replacing it in that way it gives all the records from the database. I have replaced the & by Ascii value of it(&) and its working. inputSQL.Replace("&", "&"); Thanks, Umesh Tayade