Thanks Phil. This is great information.

JP

Great. Both examples from SSC Veteran and ratbak helped me. Thank you both!

Yes, I checked refnum is int in both tables and updated the desc but still receiving blank rows.

Thank you, Scott! This works perfectly. I didn't know how to put it all together. Thank you everyone for your help.

JP

Humm... I couldn't get it to work.  You gave: 'USE ? select DB_NAME(DB_ID(''?''))

But I don't know the database name. The server has many databases. I want to search all the...

Great advice. I'll look into it.

Thank you.

JP

Thank you for your feedback.

We are using the developer version of SQL Server and will use the same to set up the new server. I have access to the current...

Thank you. I'll give it a try.

Thanks Brian and  Frederico!

I ended up putting it in a string strComment = Replace("(Me.Comment)", "'", "''")   and used the string in the update statement.  It worked perfectly.

Thanks,

JP

You said:  I have programmed many scanners, the latest being Android and they normally have a wedge app that can scan a code and paste into another app or if...

Thank you for your advice.  While shopping for the device I'll keep the storage in mind.

Thanks,

JP

Thank you for your advice!  Yes, the scanner will be used in the warehouse.  I will keep that in mine.

Thanks,

JP

Thank you Bredon!

Regards,

JP

Thank you Ant-Green and Irish for your feedback.  Very well thought out details for me to consider.

Thanks again!

JP

Great.  I found this link: “https://azure.microsoft.com/en-us/pricing/details/sql-database/single/”

It shows 2 vCore and DTU, serverless that Ant-Green mentioned.  This page calculates the cost if I choose basic or standard tier on the DTU...