Then I guess you're concatenating two source columns. Have you tried remapping them?

Hi Venki

Can you post the script for the table please? This will allow future posters to evaluate the problem.

Please read the link below, and provide table scripts and sample data, which...

No problem - what syntax did you settle for?

If there are definitely no rows with embedded single or double...

Check out LEFT() and CHARINDEX() in Books Online.

A Little Help Please (4/22/2009)

---

Thanks Chris,

Im a bit lost now...

You say I got an embedded single or double quotes in an input string which I'v designated as an output column....

Use a searched case, otherwise you're using a comparison operator which won't work with NULLs:

DROP TABLE #NullSample

CREATE TABLE #NullSample (ID INT, Something VARCHAR(15))

--

INSERT INTO #NullSample (ID, Something)

SELECT 1, 'a value'...

A Little Help Please (4/22/2009)

---

What does the following error mean?

TITLE: Microsoft Visual Studio

------------------------------

The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers...

Have you tested the SELECT part on its own?

SELECT a.*,...

You're welcome - and I'm no 'sir', just a common working person, like yourself 😀

So there are embedded tab chars in strings which look like this: 'LC157790 /TCP'

In which case Flo's function will truncate from the first tab found...

First things first - do you...

ubeauty (4/22/2009)

---

I won't be able to drop the table due to keys in place (1 primary and 13 foreign) but when using the update section of the code above:

UPDATE clientsupplier...

Check out the NVARCHAR datatype in BOL. You will need to change the size of your VARCHAR receiving column.

From BOL, the first few sentences for CREATE FUNCTION:

Creates a user-defined function. This is a saved Transact-SQL or common language runtime (CLR) routine that returns a value. User-defined functions cannot...