Discuss "query error" in the SQL Development forum.

todd2006 · #1 June 24th, 2008, 11:51 AM

Hi,

I have this query and its gives me an error saying expected end of statement

where F Name and L Name are the names of the fields

the error is at " "

Code:

SELECT [F Name] & " " & [L Name] & [S Name] AS FullName from Students

Rebelle · #2 June 24th, 2008, 12:05 PM

try something like this:

Code:

SELECT [F Name] + ' ' + [L Name] + ' ' + [S Name] as FullName FROM Students

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
XML Node Error	noFriends	Visual Basic Programming	4	June 3rd, 2008 08:57 AM
Wizard1 error The command 'MoveComplete' is not valid	peebman2000	.Net Development	10	April 28th, 2008 02:52 PM
[Error] Microsoft JET Database Engine error '80004005' Operation must use an updatea	theChris	ASP Development	2	March 16th, 2008 10:18 AM

Discuss "query error" in the SQL Development forum.

SQL Development - Structured Query Language (SQL) is the talk of databases. Discuss topics such as joins, triggers and other advanced SQL topics.