SCOPE_IDENTITY() SqlCe Problem

I unable to do the SCOPE_IDENTITY on a insert query at SQL Mobile.



I need to perform on this query the insert on Client table and to get the ID.

I am programming on Visual Basic on Visual Studio 2005



My code is:



Dim ClientID as Integer

Dim sql As String = "INSERT INTO Client(Number) VALUES('5'); SELECT scope_identity()"

Dim cmd As New SqlCeCommand(sql, connection)



connection.Open()

ClientID = Convert.ToInt32(cmd.ExecuteNonQuery())

connection.Close()



And I get an error like this:



There was an error parsing the query. [ Token line number = 1,Token line offset = 76,Token in error = SELECT ]



Thanks!