Combine these fields to form a SQL string

tradertt · Jul 28th 2006

Hi

Please take a look at the example given

I have a whole list of fields that I wish to combine into a certain string,
As there are too many fields including all the , ' ; etc Concantate may not be able to do it ....

Anonymous · Jul 28th 2006

Re: Combine these fields to form a SQL string

This is not difficult. I haven't done it all, but here is the beginning:

="INSERT INTO 'games' VALUES ("&A2&", '"&B2&"', '"&C2

which gives

INSERT INTO 'games' VALUES (1000, 'African Mask', 'A challenging puzzle game

Carry, noting that numeric fields do not need the single quotes, but text fields do.

Combine these fields to form a SQL string

Participate now!

Share