where two column match one column

[Guest]

hi in my where clause i need to match 2 column to 1

ie
session.CODE = 33
SN.code45= 5555

So what i need is session.CODE and SN.code45 (together with no space) = from

335555 = from

[Dan_Bracuk]

If these are cold fusion variables you can simply concatonate them.

[Newsgroup_User]

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,
len(formvalue)-2)#

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Guest]

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

ie 446666

so i need to input 6666, how would i drop the 2 numbers off, before i do my insert?

[Newsgroup_User]

what exactly did you try? can you post your code that did not work?

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[Guest · Accepted solution]

right(myString, len(myString)-2)