Hi Guys,



Here's the deal...



I have a table, in this table there are 9 columns.



There is a value called customerreference which appears only once in a
row but can appear in any one of the columns. What I want to do is only
select the particular value customerreference but obviously I cannot do
this from the once column as it appears randomny.



i.e



row 1 customerreference in col003

row 2 customerreference in col002

row 3 customerreference in col002

row 4 customerreference in col005

row 5 customerreference in col008

row 6 customerreference in col002

row 7 customerreference in col003

row 8 customerreference in col003

row 9 customerreference in col004



AlI I want to do it get a select that returns a list of just the
customerreference value.



Thanks

Steve




________________________________________________________________________
FFastFill plc is a public limited company registered in England and Wales with details as follows;
Registered Office: 1-3 Norton Folgate, London E1 6DB Company Number:978346

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[Email address protected]

This email has been scanned for all viruses by the FFastFill Email
Security System.
________________________________________________________________________

MS Sql Server LazyDBA home page