You should use Google...
http://msdn.microsoft.com/en-us/library/ms178030.aspx[
^]
select
xmlfield.value('/CasteCertificate/ApplicantCAddress1', 'varchar(max)') AS ApplicantCAddress1,
xmlfield.value('/CasteCertificate/ApplicantCAddress2', 'varchar(max)') AS ApplicantCAddress2,
xmlfield.value('/CasteCertificate/ApplicantCAddress3', 'varchar(max)') AS ApplicantCAddress3
from
Table