How do I prompt the user to enter an 8 character code that I will use in an MS SQL query script?

You may be having a slight problem with terminology & functionality.

SQL (Structured Query Language) is a language that OTHER systems (PHP / C / C++ / Java / Basic) can use to interrogate a database. This is a 'backend' language and doesn't normally have any user interaction.

The language that you use to call SQL stored procedures, or building SQL queries, is responsible for handling all user interaction and then building the SQL script with the required parameters in the correct place(s).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.