Bizaare Field joinging issue

[dubmunkey]

Hi all,

i have a query which joins the email fields from a table-a table which has an email address for every teacher of a student in our school- up until a while ago this worked perfectly:

and would get

studentid | email
1234 | [art teacher email]; [biology teacher email] etc etc


but since having added two new subjects i only ever get a blank value-

so using a reduce version which just joins the first two email fields like this:

SELECT dbo.EmailTable.studentid, dbo.qxStudents.Forename + ' ' + dbo.qxStudents.Surname AS Student,
dbo.EmailTable.AR + dbo.EmailTable.[AR/AS] AS Expr1
FROM dbo.EmailTable INNER JOIN
dbo.qxStudents ON dbo.EmailTable.studentid = dbo.qxStudents.StudentId


also doesn't work giving me this:


studentid| expr1|

1076 | |


now if i add in the two fiels im joining to check there are values i get this:


studentid | Expr1 | AR | AR/AS|
4035 | |l******@pgs.org.uk; | |
where as i used to get:


studentid |Expr1 |AR |AR/AS|
4035 |l**********@pgs.org.uk;;| *********@pgs.org.uk; | |


so i simply can't work out why it will show me the field values but will not join them into the new Expr1 field when it always used and wont throw up any errors in the process?

the table field type for the emails are char- ive tried varchar- didn't make a difference....

can anyone help?

dubs