Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>Hi Guys,
>
>I have a table that has around 100 columns. For each record, not all columns have values.
>
>Example :
>Row1 = Pkeyno, Column1, Column5, Column10, Column 15.... have values
>Row2 = Pkeyno, Column2, Column4, Column13, Column 114.... have values
>
>Is it possible to do a Select statement using the pkeyno as the where clause that would return all columns with values only?
>
>Thanks in advance....
Please provide some sample data like the current file and some sample data for the result you want to see.
Previous
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