Home Forums SQL Server 7,2000 Administration Pipe Symbol as Column delimiter RE: Pipe Symbol as Column delimiter

  • August 13, 2008 at 2:18 am

    #857225

    I am exporting records by using Stored procedure. The master table contains many coulmns, I needed to export all master table columns (10 columns) into .dat file,

    eg of the master table.,

    Column names: FirstName, LastName, Address, Phone, Pin

    so all these result set sould be pipe delimited in the .dat file.,

    SELECT ISNULL(FirstName,'') + CHAR(124) + ISNULL(LAstName,'')+ CHAR(124) +ISNULL(Address,'')+ CHAR(124) +ISNULL(Phone,'') from table.

    Thanks

    [font="Comic Sans MS"]Sara[/font]

    A ship in the harbour is safe . . . but that's not what ships were made for. 😀