Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert Binary to String for SQL Update
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Convert Binary to String for SQL Update
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01524435
Message ID:
01524435
Views:
89
Hi,

I have a SQL query that selects PersonID, which is a Binary - 10. I need to build a SQLQuery string to update a different table with various values, including the PersonID. How do I convert the PersonID to a string, suitable to include in my "Update Table2 set PersonID = ????"

Thanks!
Next
Reply
Map
View

Click here to load this message in the networking platform