I have a movie database some how I've got some file path with a new line character
How do I locate these?
Msg 402, Level 16, State 1, Line 12
The data types varchar and char are incompatible in the '|' operator.
SELECT * FROM "file" WHERE path like '%' | char(13) | '%' or path like '%' | char(10) | '%';
Once I've found then I'll need to remove the "\n";
But I think there is going to be duplicate
and the file . id is a foreign key
BTW It is a MS SQL database