Carriage Return 1

[ckugo]

Can someone please tell me what the carriage return symbol is in SQL??
Here is my statement:

UPDATE Illness SET Illness.[Notes] = "SPU=[K89034] SPL=[SMITH] SPF=[JOHN]"
WHERE (((Illness.Notes)<>""));

I a carriage return to be between SPU, SPL, and SPF.

Any help at all is greatly appreciated.

Thanks,

Chris

 

[PHV]

UPDATE Illness SET Notes='SPU=[K89034]' & Chr(13) & 'SPL=[SMITH]' & Chr(13) & 'SPF=[JOHN]'
WHERE Notes<>"";

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ckugo]

Thank you so much PHV. Works like a charm.