Help with regex...fetching part from string

[belick]

I need to fetch part of a string that can be anyting. The roll is basic:
starting with " dbo." ending with ".(.*) " I think

botom line I need to fetch:  "dbo.AnyTableHere.AnyField" when "AnyTableHere" can be anything etc...


(CASE WHEN dbo.AnyTableHere.AnyField = 1 THEN dbo.T_Trucks.TruckName END)

thanks ahead!!!

[effigy]

[code]
<?php
$string = '(CASE WHEN dbo.AnyTableHere.AnyField = 1 THEN dbo.T_Trucks.TruckName END)';
preg_match_all('/dbo\.(.+?)\./', $string, $matches);
array_shift($matches);
echo '<pre>', print_r($matches, true), '</pre>';
?>
[/code]