Hi,
This query will definately solved your purpose
SELECT 'A' + cast(substring(Max(fieldname),2,2)+1 As Varchar) FROM tablename
Parvez Khan <[EMAIL PROTECTED]> wrote:
Hi Group,
Actually i have a table column sDept_id char(3) and if i go for select
max(sDept_id) the result comes A01
i have to add 1 in A01 so what it becomes A02.
Please send me the complete query.
How do i do that?
Please send me the complete query.
Thanks in Advance
Ragards
Raj
[Non-text portions of this message have been removed]
SPONSORED LINKS
Programming languages C programming language Computer programming languages
Java programming language C programming language History of computer
programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
