Re: Escape character weirdness
- From: David Thielen <david@xxxxxxxxxxxx>
- Date: Tue, 11 Apr 2006 09:31:10 -0600
Hi;
Just tried it - didn't work (good idea though).
thanks - dave
On Tue, 11 Apr 2006 08:18:30 -0700, Joe Weinstein <joeNOSPAM@xxxxxxx>
wrote:
David Thielen wrote:
Hi;
This works:
SELECT * FROM demo WHERE (name LIKE 'Da[%]ve')
This dies not:
SELECT * FROM demo WHERE (name LIKE 'Da\%ve') - it returns no rows
Did you try:
SELECT * FROM demo WHERE (name LIKE 'Da\\%ve')
Yet DatabaseMetaData.getSearchStringEscape(); returns "\\".
Any ideas as to what is going on?
Sql Server 2000 and latest JDBC driver.
thanks - dave
david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
.
- Follow-Ups:
- Re: Escape character weirdness
- From: Joe Weinstein
- Re: Escape character weirdness
- References:
- Escape character weirdness
- From: David Thielen
- Re: Escape character weirdness
- From: Joe Weinstein
- Escape character weirdness
- Prev by Date: Re: Escape character weirdness
- Next by Date: Re: Unexpected Exception when inserting data in SQL 2000
- Previous by thread: Re: Escape character weirdness
- Next by thread: Re: Escape character weirdness
- Index(es):
Relevant Pages
|
