Insert Command

[bdjb]

I'm pulling data from a strange database, there is a FieldNum id that denotes what data another field is (If Fieldnum = 31 then Answertext = State, Fieldnum = 92, Answertext = County). Is there a way add criteria to the Insert command such that if FieldNum = 92 it populates the County field etc?

Thanks in advacne!

 

[simian336]

You just need to do an update command after you do you inserts. Then just update the appropriate fields.

Simi

 

[simian336]

Update table
set State =Answertext
where Fieldnum = 31

update table
Set County=Answertext
where Fieldnum = 92

Simi