Retrieving 'Credit' when 'C'

Hello,<br /><br />Does anyone know how to make a Select that even having a Char(1) with the letter C the statement
makesthe rows appearing 'CREDIT' ?<br /><br />Like: <br /> On table:<br /><br />When         Type<br />2007-01-01    C
<br/>2007-01-02    C<br />2007-01-03    C<br /><br />On SQL result<br />When         Type<br /> 2007-01-01    CREDIT<br
/>2007-01-02    CREDIT<br /> 2007-01-03    CREDIT<br /><br />Thanks in advande,<br /><br clear="all" /><br />-- <br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=<br/>                                  Atenciosamente
(Sincerely)<br/>                        Ezequias Rodrigues da Rocha<br />
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhor do
quea melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships<br /><a
href="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>