String nach einem Teilstring durchsuchen
| ID | 138 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | T-SQL |
| PlGroup | Datenbank |
| PlItemTitle | String nach einem Teilstring durchsuchen |
| Code | -- Find characters which are also special characters for search terms, e.g. % or _ -- see also: http://msdn.microsoft.com/en-us/library/ms179859%28v=sql.105%29.aspx SELECT * FROM table_1 WHERE column_1 LIKE '%!_%' ESCAPE '!' -- Find results which includes the character "_". The escape character is defined as "!" |
| Result Example |