Thanks... yes, of course (I was being particuarly dumb)

--- In firebird-support@yahoogroups.com, "Nick" <nick@...> wrote:
>
> use single quotes '09'
>
>
>
> --
> Nick
> -----We Solve your Computer Problems---
> UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of willogibbo
> Sent: 06 March 2006 14:00
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Saving string value with leading zeros?
>
>
> I have a field in a table designated as a char(2) type and I am trying
> to update it with a value of "09", but when I do this it, the value
> written into the table is just "9" i.e. the leading zero is removed.
>
> How can I retain the string value as "09"?
>
> Many thanks
> Will
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
>
> SPONSORED LINKS
> Technical
>
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
>
w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq
>
+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technic
> al+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> support Computer
>
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical
>
+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&
>
w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsof
> t+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA> technical
support
> Compaq
>
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Te
>
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
>
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=M
> icrosoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>
computer
> technical support
> Compaq
>
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+s
>
upport&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4
>
=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+
> technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w> technical
support
> Hewlett
>
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Te
>
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
>
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=M
> icrosoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>
packard
> technical support Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technica
>
l+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support
>
&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microso
> ft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw> technical
> support
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been removed]
>