Concatonate numeric fields in a Where statement

Question

Hi,

I am wanting to concatenate four fields together from one table with four fields together from another table in a where statement within a subquery.

How would I go about acheiving this

At the moment in time my cutdown SQL looks like

Select
    T1.ASSR_FEE as AssessorFee,
    T1.CAU_DT as Comment,
    (select Full_Desc from Sy_code_list t5 where t5.ID_Code = t4.ID_Code and t5.Level_2 = t4.Level_2 and t5.ID_Code = 5 and (t5.Level_3 = 0 or t5.Level_3 = -1)) AS MainDescription
FROM
    (((cl_details T1)
    LEFT OUTER JOIN [C:\Users\cjack\Desktop\Test Stuff\ecm_hol.mdb].tb_pers T2 on T1.pers_no = T2.ref_id)
    LEFT OUTER JOIN [C:\Users\cjack\Desktop\Test Stuff\ecm_hol.mdb].tb_pers T3 on T1.insp_id = T3.ref_id)
    LEFT OUTER JOIN cl_coding T4 on T1.cl_id = T4.cl_id

So I am wanting to concatonate t5.id_code with t5_level1 etc

Thanks

Answer 1

Hi,

Not sure I follow but the symbol for concatenation is "&." Have you tried using it?

If you can post some sample data (before and after), it might help us figure out what you mean.

Hope it helps...

Answer 2

Hello Jak82,

What do you mean "concatonate"? Could you please detail us for this?

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].