answersLogoWhite

0

v can concatenate two string by using a function like: select CONCAT( CONCAT('ename','e_mrks'),"name","marks" from student;

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

A Write the algorithm to concatenate two given strings?

a write the algorithm to concatenate two given string


What to do with two peaces of normal string?

Whatever you want. Concatenate them, for example.


What is the souce code of a b c and abc in vbnet?

In VB.NET, you can define variables a, b, and c, and then concatenate them to form abc like this: Dim a As String = "a" Dim b As String = "b" Dim c As String = "c" Dim abc As String = a & b & c This code initializes three string variables and uses the & operator to concatenate them into a new string abc.


Does the CONCATENATE function in Excel require a text argument?

Normally yes, but it will actually take numbers and combine them into a text string.


How do you convert an integer to a string?

That really depends on the programming language. In Java, it is sufficient to concatenate it with a String: int myNumber = 5; result = "" + myNumber; Other languages may require a special function, or method, to convert from integer to string.


What symbol is use to join strings?

Language dependent. In C, for example, there no string as such, but you can use function strcat to concatenate zero-terminated character-sequences.


How do you concatenate char with int column in sql?

In MS SQL, you can use the char() operator on the column. For example: select 'some string content ' + char(integer_field) from my_table


How do you use the Scanner class to store two words or more in a String variable then the next input in another String variable in java?

Scanner scan = new Scanner("[input method]"); // input method could they key board //(System.in) or a String String one = scan.next() + scan.next(); // get the first 2 words and concatenate String two = scan.next(); // the remaining word


C program to concatenate two strings?

#include#includevoid main(){char a[30],b[30];clrscr();printf("Enter the string a:");gets(a);printf("Enter the string b:");gets(b);printf("%s",strcat(a,b));getch();}


What is concatetion operation used in java?

"+" is the concatenation operator in Java. It can be used to concatenate two strings. Ex: String firstName = "John"; String lastName = "Morrison"; System.out.println(firstName + " " + lastName); The above code snippet would display John Morrison in the console.


Diff between string and array?

String and array are not related to one another so they have many differences. a. A string is used to hold alpha numeric values inside it b. An Array is used to hold multiple values of any primitive data type c. A String has operations like equals, concatenate, substring etc whereas an array does not have them d. You can iterate through an array but we cannot iterate through a string.


What is concatenate function in c?

strcat


What is concatenate key in a relational database?

The concatenate key is simply the combination of several columns in a table, which serves the unique key of that table.


What character allows you to concatenate strings in PHP?

To concatenate strings in PHP, you use the . (dot) character. For example: $str = "String1" . "String2";


How do you concatenate text in Microsoft Excel?

You can concatenate using the & operator. So say you have a firstname of a person in cell B2 and their surname in cell C2 and in D2 you want to display their first name, a space and their surname together, you would do this: =B2 & " " & C2 You could also use the CONCATENATE function to do the same thing: =CONCATENATE(B2," ",C2)


Where do you go in Excel to concatenate?

Concatenating is joining bits of data together, like two separate pieces of text into one piece. There is a function called CONCATENATE or you can use the & symbol. Both of these will do the same thing: =CONCATENATE( "ABC" , "DEF" ) ="ABC" & "DEF"


Interview questions on C?

Different data types,pointers,simple programs like factorial,palindrome etc,quick and bubble sort,use of %u,simple string functions like copy,concatenate.


What is concatenate?

Concatenate in MS Excel and most of other tool is function to join text.


How do you add text together in Excel cell?

You can concatenate text either using the CONCATENATE function or the & operator. If you had text in cell A2 and cell B2 that you wanted to add together in another cell you could do it in either of these ways: =A2 & B2 =CONCATENATE(A2,B2)


How do you use string operators in qbasic?

In QBASIC, string operators allow you to manipulate and combine strings. The primary operator is the concatenation operator, which is the semicolon (;) or the plus sign (+). For example, you can concatenate two strings like this: result$ = "Hello" + " World", resulting in result$ containing "Hello World". You can also use the LEN function to get the length of a string and the MID$, LEFT$, and RIGHT$ functions for extracting parts of strings.