how can i identify this character or reproduce it?

below is a record in the results window pane in sql server management studio.

notice the arrow character
notice in the picture above the "arrow" character pointing to the right between "BP" and "Remaining". this field is type varchar(1024). if I copy this field in the results pane and paste it into the query pane above, I get the following:

notice the box character
notice how the "arrow" character is now a box with what looks like a question mark without the dot.

my question is how can I find out what character this is and how I can reproduce it. I can certainly query the table for this by using the where statement below:

notice i retain the square character
anybody have a clue? please ask if you have questions and I will clarify the best I can. the text editor font is consolas. I can change the font but that's doesn't help as when I change it to courier, it displays as a square box.
Bryon HuffmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Declare @char varchar(100) = 'copy-paste your string here'
SELECT ASCII(SUBSTRING(@char, 11, 1))

Then google 'ASCII Character Set' and look up what that character translates to.

btw if you are in hell with all of these characters I highly (HIGH - LEE) recommend downloading a trial of UltraEdit, where you can open any file, do a Ctrl-H, and look at the Hex value of every character.  There are other text editors-on-steroids apps out there, but this is the one I'm familiar with.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Haris DulicCommented:
can you do this:

select ascii(substring(column_name, 11, 1)) from table_name where column_name like '%BP%Remaining%' 

Open in new window


it should get the ascii code of that character and then you can query it..

YOu can use this site to lookup for codes or representation of those codes  http://www.lookuptables.com/
0
Bryon HuffmanAuthor Commented:
the early bird gets the worm. Jim was the first to answer correctly.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.