This content has been marked as final. Show 5 replies
If these are cold fusion variables you can simply concatonate them.
depending on the type of db you are using you may have some
concatenation functions available to you - check the sql language
reference for your db.
otherwise, if you form value you are checking against is of fixed format
- i.e. first 2 characters (to be checked against session.CODE) + other 4
characters (to be checked against SN.code45) - you can use:
session.CODE = #left(formvalue, 2)# AND SN.code45 = #right(formvalue,
hi tried that but with no success, so i will go another way and input the number to the table, but drop the first 2 number off
so i need to input 6666, how would i drop the 2 numbers off, before i do my insert?