How convert NULL to empty string in select statement?

Hello:

I was wondering, given the following select statement is there an easy was
to return an empty string for the FirstName field if the value is NULL? I'm
not quite sure of the necessary syntax:

// If FirstName IS NULL, FirstName should = ''
SELECT FirstName, Age, State FROM Customers WHERE CustomerID = @CustomerID

Thanks,
Chris

Select IsNull(Firstname, '') As 'Firstname', Age, State From Customers
Where CustomerID = @CustomerID

HTH

Barry



ChrisB wrote:
> Hello:
>
> I was wondering, given the following select statement is there an easy was
> to return an empty string for the FirstName field if the value is NULL? I'm
> not quite sure of the necessary syntax:
>
> // If FirstName IS NULL, FirstName should = ''
> SELECT FirstName, Age, State FROM Customers WHERE CustomerID = @CustomerID
>
> Thanks,
> Chris