|Subject:||Skip rows where the first column with letter 'S' - BCP|
|Date:||9 Aug 2006|
I have this data file with fix length(see below). I am able to insert
it into the database using bcp, but now I want to skip (do not insert)
the row which start with letter 'S' into the database. Is there away to
do it? By the way I am using -F2 option to skip the first record.
Here is my data:
Record 1 04
2 13106900240120042003040045061 Testing N POLYDOROS TRUST
2 12621241640280041004040045633 What are they MARTIN &
Thanks for your help.