instead of substring what should we use in MSACCES

miruthula · February 2nd, 2007, 07:06 AM

hi,
userdetails table:

uid username
---- --------
us101 miruthu
us102 raj

select top 1 substring(uid,3,5) from userdetails order by uid desc

if i have query like this
i got o/p
102

it is not working in msaccess.what should i use for it while am using msaccess instead of sqlserver.i want to split us and 101.what should i do.if anyone knows please reply as soon as possible

sshelper · February 9th, 2007, 12:13 PM

You can use the MID function in MS Access, which is the same as the SUBSTRING in SQL Server:

SELECT TOP 1 MID(UID, 3, 5) FROM UserDetails ORDER BY UID DESC

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp