Hi,
I have the format of the AN in Access set as: "Br"0000 and "Sr"0000 in another table.

When displaying their ID, I use:
<%="BR" & Right("0000" & myRS("Br_ID"), 4)%>

When using Querystring only Numbers are picked up which is causing me a problem. Can I include the above code in a variable (if so how)?

How do I get around this? Hope to hear...

TIA.

Some more code if it helps:

<a href="detail.asp?id=<%= myRS("Br_ID") %>"><%="BR" & Right("0000" & myRS("Br_ID"), 4)%></a>

This QS is in the Bro.asp (inc. file).

Another QS is in the Sro.asp inc file:

<a href="detail.asp?id=<%= myRS("Sr_ID") %>"><%="SR" & Right("0000" & myRS("Sr_ID"), 4)%></a>


How can I pick up the QS in the detail.asp page? The bold parts of the code only submit a number, there is no Br or Sr to differentiate.
Hope this makes sense.