I'm trying to concatenate fields in SQL stored proc for use in text
field in asp.net dropdownlist. I'm running into a problem when I try
to use a DateTime field, but can't find the answer (so far) on the
Internet. Was hoping someone here would know?
My sql stored proc:
SELECT AnomalyID, DateEntered + ', ' + Station + ', ' + Problem As
'SelectInfo'
FROM tblAnomaly
WHERE WorkOrder=@varWO AND Signoff=Null
ORDER BY DateEntered
but I get the error:
The conversion of a char data type to a datetime data type resulted in
an out-of-range datetime value.
I'm not the brightest bulb on the block, so any clues greatly
appreciated!
Thanks, Kathy