Query

Question

Hello Sir.. I want to define a some record idnamemonth yeargender like (1'raj'5-9-20051) please define query and show output is (1'raj' 5-october-2005male)

Anupam Singh · Answer

Hi Davin you should mention you table name and column names here.Any ways. suppose your table name is [Person'] and columns are [Id][Name][Date Of Birth][SEX] then the query will be SELECT IdNameCONVERT(VARCHAR(11) [Date Of Birth] 106) AS [DOB] (case SEX when 1 then 'Male' else 'Female') as [SEX] from [Person] Hope this will help.

Jignesh Trivedi · Answer

hi there is synax error in Anupam Singh query try SELECT IdNameCONVERT(VARCHAR(11) [Date Of Birth] 106) AS [DOB] (case Gender when 1 then 'Male' else 'Female' end) as [Gender] from table hope this will help you