MySQL provides a special form of the CONCAT function: CONCAT_WS function. The CONCAT_WS function concatenates two or more string values with a predefined separator. The following illustrates the syntax of the CONCAT_WS function: CONCAT_WS(seperator,string1,string2, ...
You can usually take 25% of your pension pot as a tax-free lump sum before you take the rest of the money. You then: 1  decide how to take the rest of your pension pot if youâre in a defined contribution pension scheme.hole pension pot as a lump sum. You can usually take a whole pension pot worth up to Â£10,000 as a lump sum - 25% is tax free.
If your service is more than 10 years you are eligible for pension scheme and you will get a pension after the age of 58. If your service is less than 10 years then only you can withdraw the EPS amount but you are not eligible for pension. Lifelong pension is available to the member and upon his death members of the family are entitled for the pension. 2  A employee can start receiving the pension under EPS only after rendering a minimum service of 10 years and attaining the age of 58/50 years.