Hi

I got the solution. Thank you everybody

SELECT recordtype, recid , REPLACE(RTRIM((SELECT location+']' + ' ' FROM

temptable WHERE (recordtype = Results.recordtype and recid= Results.recid ) FOR XML PATH (''))),']...

Hi,

This working fine. But, if I want to check for a table which is in other server or other database this command is not working. Can any body help me...

Thank you, :Whistling: this helps me to reach my requirement.

Thanks Arun,

I have tested with test data. It is working. I will try with real data. Thanks alot for your solution.

-- =============================================

-- Author: VBPROGRAMMER1986@GMAIL.COM

-- Description: THIS FUNCTION IS IMPLEMENTAION OF ORACLES'S INITCAP FUNCTION

-- =============================================

CREATE FUNCTION [dbo].[INITCAP] (@sInitCaps varchar(2000)) RETURNS varchar(2000) AS

BEGIN

DECLARE @nNumSpaces int,

@sParseString varchar(8000),

@sParsedString varchar(8000)

:Wow:Thanks for the reply. This...