Creating a New Field with a CHAR field and a FLOAT field.

From: David C (anonymous_at_devdex.com)
Date: 07/18/04 

Date: Sun, 18 Jul 2004 16:32:51 -0700

Hi All,

I seem to be stumped at the moment,

All I would like to do is join a Customer Name field (CHAR) with a
Customer Number field (FLOAT) to get something like this "Joe Bloggs -
998477771".

When I try to do this the CONVERT or CAST function stuffs up my FLOAT
field giving me strange decimal numbers.

Can anyone help?

Cheers
David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Storing objects in SQL Server table
    ... A second object that is a collection of Customer objects: that is: ... - A third object that includes int, string, float and Customers. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Fri. 9/22 Will it Float? Soothsaying
    ... "Will It Float" will not air tonight. ... (fortified with 3 customer reviews!) ...
    (alt.fan.letterman)
  • Re: Creating a New Field with a CHAR field and a FLOAT field.
    ... Why are you using Float for a customer number? ... Why not make it a CHAR or ... > field giving me strange decimal numbers. ...
    (microsoft.public.sqlserver.programming)
  • Re: Fri. 9/22 Will it Float? Soothsaying
    ... "Will It Float" will not air tonight. ... (sprinkled with 9 customer reviews!) ...
    (alt.fan.letterman)
  • Re: weird problem
    ... I already told you that the comparison between an integer and a float ... to strcmpwhich expects a pointer to a string. ... And now a question about something else: why do you use floating ... int,float, char, etc. ...
    (comp.lang.c)