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 you then put this amount into a pension as a 40pc taxpayer, the tax relief comes to Â£3,864 and the value of your pension pot will be Â£9,660.This is a 93pc return and Â£2,415 more than if you had invested in a pension at the outset.f you then put this amount into a pension as a 40pc taxpayer, the tax relief comes to Â£3,864 and the value of your pension pot will be Â£9,660. This is a 93pc return and Â£2,415 more than if you had invested in a pension at the outset.