Member Avatar for hery

Hello,

when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks

Edited by hery because: n/a
  • 3 Contributors
  • 2 Replies
  • 112 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by manoshailu
Member Avatar for maheshsayani

Hi,
Below code can helps you..

convert(numeric, ISNULL(quantity, '0'))

Member Avatar for manoshailu

Hi,

Maheshsayani is right but dont use the single quote when you r trying to change the varchar to numeric.

convert(numeric, ISNULL(quantity, 0))

Have a nice day
Shailaja


Hi,
Below code can helps you..

convert(numeric, ISNULL(quantity, '0'))

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.