 | |
LIKE search statement for a '%@%'
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
LIKE search statement for a '%@%' -
06-28-2008
, 08:20 PM
#2
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#3
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#4
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#5
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#6
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#7
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#8
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#9
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
#10
| |||
| |||
|
|
Does anybody know why searching for a string '@' with LIKE does not work even when you use ESCAPE Very strange...... Say the field has ..... I love my @*&!& friend And I want to SELECT this row when I search for @ with LIKE Select * from myTable where myField like '%@%' does not work Select * from myTable where myField like '%#@%' escape '#' does not work either Select * from myTable where myField like '%' + char(64) + '%' does not work either What a pain in the something search + Why me Any help??? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.