Professional Web Applications Themes

Hex values - Microsoft SQL / MS SQL Server

Is there a way to cast or convert a int type value to HEX in T-SQL (trigger or stored proc) ex 1000 to 03e8 THanks KT...

Sponsored Links
  1. #1

    Default Hex values

    Is there a way to cast or convert a int type value to HEX in T-SQL (trigger
    or stored proc)
    ex 1000 to 03e8
    THanks KT


    Sponsored Links
    Guest

  2. #2

    Default Re: Hex values

    Hi,

    You can use a undoented call, xp_varbintohexstr


    DECLARE bval BINARY(4), hexstr VARCHAR(255)
    SET bval = 1000
    EXEC master..xp_varbintohexstr bval, hexstr OUTPUT
    PRINT hexstr

    --
    Dinesh.
    SQL Server FAQ at
    [url]http://www.tkdinesh.com[/url]

    <KT> wrote in message news:ubyXXRMQDHA.1720TK2MSFTNGP11.phx.gbl...
    > Is there a way to cast or convert a int type value to HEX in T-SQL
    (trigger
    > or stored proc)
    > ex 1000 to 03e8
    > THanks KT
    >
    >

    Dinesh.T.K Guest

Similar Threads

  1. read row values from datagrid and populate in new datagrid values from connected
    By antonia gogaki via DotNetMonster.com in forum ASP.NET Data Grid Control
    Replies: 5
    Last Post: April 21st, 01:38 PM
  2. ASP getting values
    By LC in forum ASP Components
    Replies: 0
    Last Post: July 28th, 05:19 PM
  3. how to get URL values into swf - pls help me
    By ssipl in forum Macromedia Flash Actionscript
    Replies: 2
    Last Post: February 14th, 02:36 PM
  4. Why don?t the location values in the Sprite Overlay agree with the values
    By adiabatic webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 3
    Last Post: January 6th, 04:30 AM
  5. Adding custom values and database values to DropDwonList
    By William F. Robertson, Jr. in forum ASP.NET General
    Replies: 0
    Last Post: July 1st, 06:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139