i want to know difference between ' [_^a_]%' and '_[^a]_%' while searching a string pattern?

Question

0.00/5 (No votes)

See more:

SQL-Server

SqlDataSource

SQLite

, +

Select * from teacher where firstname like '_[^a]_%'

Select * from teacher where Firstname like '[_^a_]%'

Posted 11-Nov-14 12:58pm

syedmas

Add a Solution

Comments

PIEBALDconsult 11-Nov-14 19:14pm

The second one looks wrong.
Outside the brackets, the underscore means "any one character"; inside the brackets it means underscore.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RossMW · Accepted Answer · 2014-11-11T13:52:00

Solution 1

See http://msdn.microsoft.com/en-us/library/ms179859.aspx[^]

[] indicates a list and _ a single character so {_^a_] is a bit contradictory. It will run but is a basically wrong.

'_[^a]_%' will return everything where the second character is not an a

Posted 11-Nov-14 13:52pm

RossMW

Comments

PIEBALDconsult 11-Nov-14 20:29pm

everything >> with at least three characters << where the second character is not an a

syedmas 11-Nov-14 23:08pm

thanks @PIEBALDconsult

RossMW 11-Nov-14 20:37pm

True. Thanks

syedmas 11-Nov-14 22:46pm

Thank you so much clearing the doubt @RossMw. i was just suprised a bit when i ran both the queries i could see the second query fetching me data such as 'Aadam' and many more.

i want to know difference between ' [_^a_]%' and '_[^a]_%' while searching a string pattern?

1 solution

Solution 1

Add your solution here

Preview 0

i want to know difference between ' [_^a_]%' and '_[^a]_%' while searching a string pattern?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us