@LutzM

It works when i run it direct in the sql server however when i try integrating the sqlsrv function to make it work with my php code...

Thanks

I will definately try it, because I nearly went crazy trying to figure out the correct syntax...

Ok will do...

I did but will check over again