brasso_42
asked on
ASP.Net add formating to MSSQL query result
Hi
I need to add some html formatting to a mssql query result. E.g.
Select Salu + '<br>' + Fname + '<br>' + Sname
From NamseTable
where id = 1
Result = mr <br> john <br> smith
formated in html as
mr
john
smith
The above works fine, but I want to format fname to be font arial size 10pt and italic e.g.
mr
john
smith
I am then going to use this as a message body using EWS (if your wondering)
Many thanks
Brasso
I need to add some html formatting to a mssql query result. E.g.
Select Salu + '<br>' + Fname + '<br>' + Sname
From NamseTable
where id = 1
Result = mr <br> john <br> smith
formated in html as
mr
john
smith
The above works fine, but I want to format fname to be font arial size 10pt and italic e.g.
mr
john
smith
I am then going to use this as a message body using EWS (if your wondering)
Many thanks
Brasso
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
spot on many thanks
http://www.w3schools.com/tags/tag_font.asp