Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
raysefo
Constraint Violating Yak Guru
260 Posts |
Posted - 2011-12-26 : 08:44:35
|
Hi,I am trying to use IN clause in my query as follows:...where mbv.segment in ('Bronze') and mbv.Status in ('Iptal')But I think because of Turkish character in my second IN clause ('Iptal'), query does NOT return results even there are 'Iptal' records in DB. How can I fix this?Best regards. |
|
raysefo
Constraint Violating Yak Guru
260 Posts |
Posted - 2011-12-26 : 08:46:49
|
Iptal supposed to be capital 'i' |
|
|
raysefo
Constraint Violating Yak Guru
260 Posts |
Posted - 2011-12-26 : 09:06:47
|
Hi,below solved the issue...mbv.segment in ('Bronze') and mbv.Status in (N'Iptal') |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-12-27 : 08:09:23
|
Yes for unicode characters you need to prefix with upper case NMadhivananFailing to plan is Planning to fail |
|
|
|
|
|