C# Escaping string character
Escaping string using @
string path = @"C:\Program Files\Microsoft Visual Studio 10.0\";
On mssql escaping character using ESCAPE
WHERE mycolumn LIKE '%\_%' ESCAPE '\'
SELECT isTrack.id AS [translated_pf], platformno FROM stationtrack INNER JOIN isTrack ON isTrack.name = stationtrack.track WHERE stationcode = 'KL' AND isTrack.id LIKE '%KL\_%' ESCAPE '\' ORDER BY platformno ASC;
References
Why does using an Underscore character in a LIKE filter give me all the results - https://stackoverflow.com/a/19588588/10763264
Escaping in C#: characters, strings, string formats, keywords, identifiers - https://www.codeproject.com/Articles/371232/Escaping-in-Csharp-characters-strings-string-forma
Ulasan