CODEWITHSUNDEEP
sql-serverdatabase
Nandish
Nandish

Reputation: 502

Unable to get result using Where condition in SQL server

I am working in Database since past few years but never got struck in this type of problem. The problem is when I am firing simple query Select * from Courses where subject_detail='Art History' it is giving me 0 results. My data type for subject_detail is nvarchar(50) and I am using SQL server.

Upvotes: 0

Views: 84

Answers (1)

JBrooks
JBrooks

Reputation: 10013

I can see this not working if you have spaces at the end. 

where trim(subject_detail)='Art History'

Upvotes: 1

Related Questions