SELECT a String record from a table

Looks like the record has junk characters (??) at the end.

Please try:

DECLARE @Tablename TABLE 
(Stringtype nvarchar(4000) not null)
INSERT INTO @Tablename VALUES ('/Apprecord/‎‎')
SELECT * FROM @Tablename
WHERE Stringtype = '/Apprecord/'
SELECT * FROM @Tablename 
WHERE REPLACE(Stringtype, '?','') = '/Apprecord/'

---

-Vaibhav Chaudhari