below is a record in the results window pane in sql server management studio.
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 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:
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.