473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

varchar concatenation and the opposite

1
Hi!can anyone tell me how to concatenate varchar and epecially if i have a varchar consisting of words seperated with space, how can i get the 2 or 3 words at different strings or varchars?
Jan 21 '08 #1
4 2481
gpraghuram
1,275 Expert 1GB
Hi!can anyone tell me how to concatenate varchar and epecially if i have a varchar consisting of words seperated with space, how can i get the 2 or 3 words at different strings or varchars?
varchar comes only in SQL space and in C/C++ it is a character pointer.
So if you want to concatenate two string then you shuld use strcat function.

Raghuram
Jan 22 '08 #2
weaknessforcats
9,208 Expert Mod 8TB
strcat is deprecated in C++. Use the string type.
Jan 22 '08 #3
Hi!can anyone tell me how to concatenate varchar and epecially if i have a varchar consisting of words seperated with space, how can i get the 2 or 3 words at different strings or varchars?
don't see what database you're using but CONCAT(STR1, STR2,...) is the normal function to use in SQL.

I also want a FUNCTION/PROCEDURE that will allow me to have split a string into many strings/numbers.
I would like something like:
EXPLODE(STR, ',')
Jan 24 '08 #4
sicarie
4,677 Expert Mod 4TB
don't see what database you're using but CONCAT(STR1, STR2,...) is the normal function to use in SQL.

I also want a FUNCTION/PROCEDURE that will allow me to have split a string into many strings/numbers.
I would like something like:
EXPLODE(STR, ',')
rmcguire-

Your input is appreciated (even though it's not in the language of the Forum), but do not thread hijack (ask your question in someone else's thread). It's very rude.
Jan 24 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Jonas Galvez | last post by:
Is it true that joining the string elements of a list is faster than concatenating them via the '+' operator? "".join() vs 'a'+'b'+'c' If so, can anyone explain why?
7
by: Paul Davis | last post by:
I'd like to overload 'comma' to define a concatenation operator for integer-like classes. I've got some first ideas, but I'd appreciate a sanity check. The concatenation operator needs to so...
3
by: Zack Sessions | last post by:
If I declare a local variable in a cursors query and append values to it with successiuve concatenations, how come SQL7 does not report an error if I concatenate a value to it that will overflow...
21
by: Scott Marquardt | last post by:
What are some good strategic approaches to using freeform text fields for data that needs to be queried? We have a product whose tables we can't change, and I need to count on a "description" field...
9
by: Rebecca Smith | last post by:
In past versions of Access it was a simple matter to create a persons full name from the three strings 'FirstName' 'MiddleInit' and 'LastName' and include a period after the middle initial. Using a...
33
by: genc_ymeri | last post by:
Hi over there, Propably this subject is discussed over and over several times. I did google it too but I was a little bit surprised what I read on internet when it comes 'when to use what'. Most...
34
by: Larry Hastings | last post by:
This is such a long posting that I've broken it out into sections. Note that while developing this patch I discovered a Subtle Bug in CPython, which I have discussed in its own section below. ...
1
by: RGow | last post by:
Hi, I'd like to know whether there is a way to alter the data type of a VARCHAR FOR BIT DATA column to be simply a VARCHAR column? I executed an ALTER TABLE statement, similar to, ALTER TABLE...
34
by: raylopez99 | last post by:
StringBuilder better and faster than string for adding many strings. Look at the below. It's amazing how much faster StringBuilder is than string. The last loop below is telling: for adding...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.