Jump to content


Photo

SQL statement


  • Please log in to reply
2 replies to this topic

#1 cachobong

cachobong
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 12 January 2006 - 10:16 AM

Hi guys! can u help me with my SQL?

here's what i want to happen...

TMP_TABLE.remarks = TMP_TABLE.state plus TMP_TABLE.zip

that is for all fields..how do i do it with only 1 SQL statement?

#2 LazyJones

LazyJones
  • Members
  • PipPipPip
  • Advanced Member
  • 78 posts

Posted 12 January 2006 - 10:29 AM

[!--quoteo(post=335816:date=Jan 12 2006, 05:16 AM:name=cachobong)--][div class=\'quotetop\']QUOTE(cachobong @ Jan 12 2006, 05:16 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Hi guys! can u help me with my SQL?

here's what i want to happen...

TMP_TABLE.remarks = TMP_TABLE.state plus TMP_TABLE.zip

that is for all fields..how do i do it with only 1 SQL statement?
[/quote]

With this lack of information, helping would be just like shooting in the dark...

What exactly are you trying to do? Insert new value, update, search? What are those values? Are you trying to add two intergers? or maybe doubles? Or trying to concat two strings?

Try to place yourself in our position and think if you could manage to help with that kind of question.


#3 cachobong

cachobong
  • Members
  • Pip
  • Newbie
  • 4 posts

Posted 12 January 2006 - 03:02 PM

[!--quoteo(post=335818:date=Jan 12 2006, 06:29 PM:name=LazyJones)--][div class=\'quotetop\']QUOTE(LazyJones @ Jan 12 2006, 06:29 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
With this lack of information, helping would be just like shooting in the dark...

What exactly are you trying to do? Insert new value, update, search? What are those values? Are you trying to add two intergers? or maybe doubles? Or trying to concat two strings?

Try to place yourself in our position and think if you could manage to help with that kind of question.
[/quote]

m sori for the lack of information

TMP_TABLE.state is varchar
TMP_TABLE.zip is also varchar

m trying to concat the 2 strings and put it into the TMP_TABLE.remarks of the same record.
m trying to update the record...

m sori agen for the lack of information...
thanks..





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users