Hi,
I want to filter DataView's rows according to a string expression which contains an asterisk(*). Unfortunately, I get an error message, since the asterisk sign is also used as a wildcard (similar to the % sign).
How can I solve this ?
How can I use a filter such as: "[ColumnName] LIKE '%2*3%' ?
Thanks,
ALONYou'll have to use escape character in front of the *. The escape charcter will be different depending on the database you are using:
<!-- m --><a class="postlink" href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp">http://msdn.microsoft.com/library/defau ... z_115x.asp</a><!-- m -->
<!-- m --><a class="postlink" href="http://www.techonthenet.com/sql/like.php">http://www.techonthenet.com/sql/like.php</a><!-- m -->
<!-- m --><a class="postlink" href="http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.sqls.doc/sqls968.htm">http://publib.boulder.ibm.com/infocente ... qls968.htm</a><!-- m -->
I want to filter DataView's rows according to a string expression which contains an asterisk(*). Unfortunately, I get an error message, since the asterisk sign is also used as a wildcard (similar to the % sign).
How can I solve this ?
How can I use a filter such as: "[ColumnName] LIKE '%2*3%' ?
Thanks,
ALONYou'll have to use escape character in front of the *. The escape charcter will be different depending on the database you are using:
<!-- m --><a class="postlink" href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp">http://msdn.microsoft.com/library/defau ... z_115x.asp</a><!-- m -->
<!-- m --><a class="postlink" href="http://www.techonthenet.com/sql/like.php">http://www.techonthenet.com/sql/like.php</a><!-- m -->
<!-- m --><a class="postlink" href="http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.sqls.doc/sqls968.htm">http://publib.boulder.ibm.com/infocente ... qls968.htm</a><!-- m -->