hex to ascii converter software download

You need the documentation for whatever this binary is coming from so that you can interpret it properly.

For all you know, some of it could be binary coded decimal, some of it could be checksums, some of it could be length values, etc.

I would be happy if I could get only the document numbers out of the strings.

So if I could convert it from hex to ASCII and then cut the doc number from in between any prefixes and suffixes - that would be great.

After checking this, you can dynamically parse them into their target format.

Just one more info, how do you know where exactly to split a hex string.

Here it is: SELECT TOP 1000 Link ID, Record ID, convert(varchar(100),SUBSTRING(Record ID,8,8)) as Fixed Asset No FROM MyDbName.dbo.Record Link where Record ID like convert(varchar,0xE01500000089FF) order by link id.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged sql-server dynamics-crm or ask your own question.

Hex To Ascii Converter Software Download