Hello. I'm using the Query Builder in JMP 13 to get my SQL data into JMP.  There is a very informative white paper on the Query Builder tool that shows how to change the modeling type and format, but I don't see anything about how to chang the data type.  I'm wondering if it's possible to change the data type through Query Builder?   My data is store as a varbinary data type in SQL.  When I use the Query Builder tool to open the data, JMP interprets varbinary as a Numeric value. However, I would like to import it into JMP as a Character data type since all the data dissapears when JMP interprets it as Numeric.    The SQL data I'm trying to import is a string of hexadecimal digits 778 characters long and begins with the prefix '0x'. When I import this data in JMP as Numeric, then I get a data table with all blank cells. A work around I've found is exporting the SQL data as a.csv, then importing it to JMP by using file->open->data with preview.  In the 'data with preview' dialog I can easily change the data type from numeric to character, but I would like to automate this with Query Builder or an Open Database() command.     I've found that once I get my hexadecimal data in JMP as a character type I can easily work with it and parse it using the Hex to Number() function.    I hope this makes sense.  Thank you for your feedback and help!   -Nick   ... View more