Har problem med dessa tre tecken [, ], | i strängar (i mitt fall i WHERE uttryck). Har letat lite på vilka escape characters men inte hittat något. Hur skulle exempelvis följande WHERE skrivas korrekt?

WHERE [Name] LIKE '[K69] Wennerberg'

Kör:
MS SQL-Server 2000
Win 2000 Adv. Srv.

Här kommer ett utdrag:


% Any string of zero or more characters. WHERE title LIKE ‘%computer%’ finds all book titles with the word ‘computer’ anywhere in the book title.
_ (underscore) Any single character. WHERE au_fname LIKE ‘_ean’ finds all four-letter first names that end with ean (Dean, Sean, and so on).
[ ] Any single character within the specified range ([a-f]) or set ([abcdef]). WHERE au_lname LIKE ‘[C-P]arsen’ finds author last names ending with arsen and beginning with any single character between C and P, for example Carsen, Larsen, Karsen, and so on.
[^] Any single character not within the specified range ([^a-f]) or set ([^abcdef]). WHERE au_lname LIKE ‘de[^l]%’ all author last names beginning with de and where the following letter is not l.


Symbol Meaning
LIKE ‘'5[%]’ 5%
LIKE ‘[_]n’ _n
LIKE ‘[a-cdf]’ a, b, c, d, or f
LIKE ‘[-acdf]’ -, a, c, d, or f
LIKE ‘[ [ ]’ [
LIKE ‘]’ ]
LIKE ‘abc[_]d%’ abc_d and abc_de
LIKE ‘abc[def]’ abcd, abce, and abcf

ex:
USE pubs

GO

SELECT au_lname, au_fname, phone

FROM authors

WHERE au_lname LIKE '[CK]ars[eo]n'

ORDER BY au_lname ASC, au_fname ASC

GO


/Emma

Tack, det gjorde susen

WHERE [Name] LIKE '[[]K69] Wennerberg'

Vad är din anledning till att använda like istället för likamed?

WHERE [Name] = '[K69] Wennerberg'

Villkoret kommer att komma ifrån ett webformulär som tillåter att man använder T-SQL sytax (så som wildcards).