Trademark

Question

Trademark

JKSQL

SSCrazy Eights

Points: 8481
More actions
April 14, 2010 at 2:35 pm

#142548

SELECT CHARINDEX('AAAAAAAA™BBBBBBBBBBBBBB',Char(153))
I can not seem to get the trademark to work in charindex

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95461 More actions · Answer 1

JKSQL (4/14/2010)
SELECT CHARINDEX('AAAAAAAA™BBBBBBBBBBBBBB',Char(153))
I can not seem to get the trademark to work in charindex

You're using CharIndex wrong... you reversed the parameters.

Try:

SELECT CHARINDEX(char(153),'AAAAAAAA™BBBBBBBBBBBBBB')

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

JKSQL SSCrazy Eights Points: 8481 More actions · Answer 2

JKSQL

SSCrazy Eights

Points: 8481

April 14, 2010 at 2:52 pm

#1151755

wow thanks. I am asleep at the wheel!

WayneS SSC Guru Points: 95461 More actions · Answer 3

Happens to all of us at some point. I initially thought it might be because the TM symbol might need to be specified as unicode.... but it turned out to be so much easier!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2