USE tempdb
go
IF Object_id('tempdb..#TestData', 'U') IS NOT NULL
BEGIN
DROP TABLE #testdata;
END;
go
CREATE TABLE #testdata
(
productname NVARCHAR(100) NULL
)
go
INSERT INTO #testdata
SELECT N'Dell 27" Monitor'
go
SELECT *
FROM #testdata
go
DONT know why you are not getting
could be datatype of prodcutname .. you are using varchar instead of nvarchar
I have tried but does not work in my DB.
Can you use manually two single quotes on dell and double quotes on asus so make sure sqlteam website is not removing the difference.
create table #quotations(quote nvarchar(150))
insert into #quotations
select 'Dell 27" Monitor' union all
select 'Dell 27'' Monitor'
select * from #quotations where quote like '%27"%'
select * from #quotations where quote like '%27''%'
drop table #quotations