What are these data type of characters?

Question

alt text

I did a select statement in sql and 1 of the column return me this. There is a need to query from that sql column, but as this is an existing system, I can only try and error.

From the characters, I have already confirmed if the numbers inside is 0015, I should get 15. Problem is as you can see above, it contains more than one number, and I have to compare the numbers.

Using SQL Server and C# programming, can some1 guide me on how to retrieve these individual numbers in sql server as well as the data type in C#

I just realise I cant see in here. Showed up in preview, will add in as image in a while — C_Rance, Dec 28 '10 at 10:20
Guess I found this link which does exactly what I need for sql http://msdn.microsoft.com/en-us/library/ms187323.aspx But incase I need in C#, does anyone has any idea? — C_Rance, Dec 28 '10 at 10:24
Can you give column name and type and the SQL for your select statement? — Quantumplate, Dec 19 '15 at 18:15

score 0 · Answer 1 · answered Jun 27 '11 at 20:14

In C#, you can directly assign ASCII codes to char. So, for instance, char c = (char)0x0041;

will assign character repesented by 0x0041, which in this case is 'A', directly to c. You can later convert to string, if necessary, by executing

string s = new string(c);

What are these data type of characters?

1 Answers1