SELECT a String record from a table

Hi I have a column with value /apprecord/, when I run the select query on the column with where condition having columnanme = '/apprecord/', it does not return any result.

SELECT * FROM dbo.Tablename

Where ColumnName = '/apprecord/'

it does not return the result, what could be the issue?