General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Merge 2 fields into one
I'm not sure what the best way to do this is. Can it be done with select-sql?
I have a table with 2 fields. One field contains Customer drawing names, the other contains vendor drawing names, Both are character fields c(30).
mytable.fvdwg
mytable.fhdwg
I want to build a cursor that contains all fvdwg's and all fhdwg's and no duplicates, in one field. mycursor.fdwg
Can we merge 2 fields into one with select-sql or will I have to use traditional methods, create cursor, insert etc...
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only