Wonder if someone would be kind enough to help me out here.
How can I amend the following so to only select the profile with the lowest value, if a value exists?
Select
ProfileID,
Name,
Profile1,
Profile2,
Profile3,
Profile4
from TblSample
- Profiles are an integer between 1 - 9
- Profiles might be repeated so that 2 or more profiles could be the same number
- The fields aren't mandatory so some profiles might be null or empty.
Many thanks
SmallTime
How can I amend the following so to only select the profile with the lowest value, if a value exists?
Select
ProfileID,
Name,
Profile1,
Profile2,
Profile3,
Profile4
from TblSample
- Profiles are an integer between 1 - 9
- Profiles might be repeated so that 2 or more profiles could be the same number
- The fields aren't mandatory so some profiles might be null or empty.
Many thanks
SmallTime