Convert MySQL SQL String into MSSQL Stri

[boswald]

Hi,

not sure if this is the right group but I want to do this in PHP so hoping this is where it goes.

I have the following MySQL SQL Select String

SELECT MENU1 AS Menu 1, MENU2 AS Menu 2, MENU4 AS Menu3, MENU4 FROM Menus

I now want to get the following:

SELECT MENU1 AS [Menu 1], MENU2 AS [Menu 2], MENU4 AS Menu3, MENU4 FROM Menus

How can this be done? I have been looking at ereg syntax but got quite lost.

Thanks.

• BO

[Anon]

$q = ereg_replace( ' ', ' [', $q );
$q = ereg_replace( '[^,]*,', '],', $q );
$q = ereg_replace( '`[ ]', '] ', $q );

Charley