They would like to do the import using a batch file and BCP seems the easiest thing to do.. can I use triggers together with this so as to have...

  One question though, What does the 'order by 1' part of the code do.

Blame the japanese for that.. they have this code fragment.

RTRIM( RTRIM( w.K_SYOHIN_NAME ), ' '  ) "SHOHINNAME",

this is an oracle code.. the oracle RTRIM can have a second parameter which...

After some thorough investigation of the code I aslo realize that some of the sequence is for the current file number. or some thing regarding cSV

I'm not the one maintaining this.. I just follow what is asked of me.. and well convert the said triggers... into SQL..

Well Books On Line is where I began to learn some like stored procedures etc.

Yeah I know but my problem is the increment part... hehehe.. I have made somewhat a short code for this and the trigger basically does this part..

Is this a good...

How about multi dimensional arrays?

Or an array of say 24 records always... so 24 entries but then the values change over time.. there are other processing.

Yup.. but I guess, the client has no permission.. anyways.

Hmmm... Well I finally got your message there... but how about the original normal width space... what the original code actually does is take off both of the normal and M...

I only know how to make one... it's a japanese character for space... and I only need to trim the ones to the right.

yup on the other one too... hehehe ..

the space I'm trimming off is not an ordinary space... it's double width... something.. unicode. something...

yup.

Great Idea you got there!.. I'll try that one. At least no more looping for me. thanks.