Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error in a calculation - framework

Status
Not open for further replies.

gruposenda

Programmer
Jan 11, 2007
51
MX
Hi :
I created a query subject definition, where there are 2 fileds : (1) Name ('Anthropology Institute') and (2) Number (1232680). I concatenate both fields like this : Name + ' (' + cast (Number, varchar (15)) + ')', but the result is 'Anthropology Institute (1.23268e+006)'. I need the answer 'Anthropology Institute(1232680)'. How can I do it ?

Regards.
Thanks in advance
 
Inspired (?) guess:

Code:
Name + ' (' + cast (Number*1, varchar (15)) + ')'

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top