swspm
asked on
Easy Access Concat?
I have done once the following sql statement in MySql
Sql = "Select Concat(Name, Age) From Profile;"
I'm now using MS Access with the same statement but it return errors, I then did some research on the net and found out that Concat is not a valid DB function.
I was given a suggestion to use the following but it didn't work
Sql = "Select (Name + '' + Age) As Combine From Profile Where (Name + '' + Age) = 'Max19';"
Why it didn't work?
It might because my Name field is Char type and Age is Integer Type
I have also tried
Sql = "Select Name || '' || Age As Combine From Profile;"
Error too
Anyone can help me on this? I need a function that is similiar to the Concat function in MySql that is capable to combine those fields and able to comapre the data properly. Thanks!
Sql = "Select Concat(Name, Age) From Profile;"
I'm now using MS Access with the same statement but it return errors, I then did some research on the net and found out that Concat is not a valid DB function.
I was given a suggestion to use the following but it didn't work
Sql = "Select (Name + '' + Age) As Combine From Profile Where (Name + '' + Age) = 'Max19';"
Why it didn't work?
It might because my Name field is Char type and Age is Integer Type
I have also tried
Sql = "Select Name || '' || Age As Combine From Profile;"
Error too
Anyone can help me on this? I need a function that is similiar to the Concat function in MySql that is capable to combine those fields and able to comapre the data properly. Thanks!
Sql = "Select (Name & Age) From Profile;"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.