$link = mssql_query("SELECT TOP 1

CONVERT(VARCHAR(50), FirstName) as FirstName,
CONVERT(VARCHAR(50), Name) as Name,
CONVERT(VARCHAR(50), PersonalCode) as PersonalCode,
CONVERT(VARCHAR(50), HomeAddress) as HomeAddress,
CONVERT(VARCHAR(50), Phone) as Phone,
CONVERT(VARCHAR(50), Email) as Email,
CONVERT(VARCHAR(50), SquareArea) as SquareArea,
CONVERT(VARCHAR(50), MortageObjectAreaTotal) as MortageObjectAreaTotal,
CONVERT(VARCHAR(50), Period) as Period,
CONVERT(VARCHAR(50), SubmitionDate) as SubmitionDate,
CONVERT(VARCHAR(50), RemainingLoadAmount) as RemainingLoadAmount,
CONVERT(VARCHAR(50), Amount) as Amount,
CONVERT(VARCHAR(50), MaritalStatus) as MaritalStatus,
CONVERT(VARCHAR(50), Language) as Language,
CONVERT(VARCHAR(50), IPAddress) as IPAddress,
CONVERT(VARCHAR(50), LastEditedOn) as LastEditedOn,
CONVERT(VARCHAR(50), ResultStatus) as ResultStatus,

CONVERT(VARCHAR(max), AdditionalInformation) as AdditionalInformation,
CONVERT(VARCHAR(255), CaseDescription) as CaseDescription,
CONVERT(VARCHAR(255), CaseDescription1) as CaseDescription1,
CONVERT(VARCHAR(255), NegotiationsHistory) as NegotiationsHistory,
CONVERT(VARCHAR(255), CreditCommitionDecision) as CreditCommitionDecision,
CONVERT(VARCHAR(255), Result) as Result,


CONVERT(VARCHAR(50), CarMake) as CarMake,
CONVERT(VARCHAR(50), CarModel) as CarModel,
CONVERT(VARCHAR(50), CarBuildYear) as CarBuildYear,
CONVERT(VARCHAR(50), CarWINCode) as CarWINCode,
CONVERT(VARCHAR(50), CarMileage) as CarMileage,
CONVERT(VARCHAR(50), CarFuelType) as CarFuelType,
CONVERT(VARCHAR(50), CarMotorPower) as CarMotorPower,
CONVERT(VARCHAR(50), CarMotorVolume) as CarMotorVolume,
CONVERT(VARCHAR(50), CarRegistryNumber) as CarRegistryNumber,
CONVERT(VARCHAR(50), CarConditionType) as CarConditionType,
CONVERT(VARCHAR(50), CarCost) as CarCost,
CONVERT(VARCHAR(50), CarSelfFinancing) as CarSelfFinancing,
CONVERT(VARCHAR(50), CarLeasePeriod) as CarLeasePeriod
FROM Application ");

CONVERT(VARCHAR(max), AdditionalInformation) COLLATE SQL_Latin1_General_CP1_CI_AS as AdditionalInformation,