>>In general I don't mind changing the type of field in SQL Server but I have to also change the type of field on the VFP side (specifically when I SQL Select or fill a Cursor Adapter). I need to test it.
Yes. In VFP View designer you can set the field to character binary which will work against whatever field type you choose on the backend.
FWIW, don't be tempted to use CHAR or TEXT in SQL Server for binary strings. They've promised to deprecate TEXT for years but (more importantly) some character combinations are quietly transformed by SQL Server for those field types which gives you an intermittent bad encryption that's expensive to debug in a non-human-readable encrypted string.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
