append data

[Prateek1]

hi,

My Question is :

USING WHEN-SELECT STATEMENTS,how can we  define a new variable providing the country of origin for each model based on the manufacturer .??

what should be the code ?

[LinusH]

Just simple assignments in each when/otherwise clause.

The syntax, check out yourself in the documentation.