All Forums Database
c19 14 posts Joined 04/07
31 Jul 2007
Byte(4) conversion?

Hi,I have a table dbc.tvm with a databaseid (which is a byte(4) type) of 0000FA8E but I'm having trouble using it in a WHERE...SELECT * FROM dbc.tvmWHERE databaseid = '0000FA8E'I have tried casting it to a byte etc but no luck.The error I am receiving is "Conversion between BYTE data and other types is illegal.Any help would be appreciated.ThanksMichael

sachinp17 53 posts Joined 11/06
31 Jul 2007

Hi, Try this... this will help you.SELECT * FROM dbc.tvmWHERE databaseid = '0000FA8E'xbRegds,sachin khade

c19 14 posts Joined 04/07
31 Jul 2007

Hi,Thanks for that it works great.Out of interest could you explain what the xb is doing?Thanks againMichael

Td.discussions 5 posts Joined 08/07
13 Aug 2007

Xb stands for hexadecimal

Jim Chapman 449 posts Joined 09/04
13 Aug 2007

More precisely, 'x' indicates that the form of the literal is hexadecimal, and 'b' indicates that the data type is byte.

You must sign in to leave a comment.