[Wolves] SQL problem

[Simon Burke]

On 17/3/04 10:35 am, "Chris Procter" <Chris at foxonline.co.uk> wrote:

> I'm a bit confused, are you trying to hold two copies of the same info, one
> in english and one in welsh? If so could you use two fields in the table e.g
> english_text and welsh_text and then pick which column you want on the fly
> (dependant on some variable set by the front end)
> i.e. "SELECT " & language & "_text FROM table"
> with language = "welsh"
> 
> Or have I missed the point?
> 
> chris
> 
True true, the only problem we have is that data needs to e interchangeake
between the both, so we need the ability to translate between the two,