473,407 Members | 2,320 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,407 software developers and data experts.

how to get maximum in alphanumeric values

375 256MB
Hi,
I want to give transaction Id to each clients
I have to check the latest transaction for the clients and then increment it with by 1.

If I have VT9 as the last transaction then the next transaction should be VT10.

I cannot use rowcount and concatenate it with the VT. because in one single transaction id I may have many rows in it.

I tried to use max(transactionid) but these does not work either.

Any help
Regards
cmrhema
Nov 10 '07 #1
1 3503
iburyak
1,017 Expert 512MB
Try this:



Expand|Select|Wrap|Line Numbers
  1. 'VT' + convert(varchar(20), max(convert(int, substring(transactionid, 3, 100))) + 1)
Good Luck.
Nov 10 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Shozi | last post by:
Dear All, My project is basically about the personal record keeping of user's data. Now user can customize their data entry form by adding/removing the desired fields for personal information...
2
by: Hennie de Nooijer | last post by:
Because of an error in google or underlying site i can reply on my own issue. Therefore i copied the former entered message in this message....
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
7
by: Fernando Rodríguez | last post by:
Hi, How can I know if a string only has alfanumeric chars? Thanks
12
by: John | last post by:
Hi How can I select records that have non-alphanumeric characters in a field using a select query? Thanks Regards
3
by: symbee | last post by:
Hi all, I want to create a string of alphanumeric values. Actually it is for security purpose. I am using C++ and I want the fuction for that... Can anybody help regarding this?? Plzzzzzzzzzzz...
6
by: =?Utf-8?B?U2hhcm9u?= | last post by:
I'm using the VScrollBar and set it as follow: m_vScrollBar.Minimum = -19602; m_vScrollBar.Maximum = 0; m_vScrollBar.SmallChange = 1; m_vScrollBar.LargeChange = 1089; m_vScrollBar.Value =...
1
by: reni | last post by:
haii, plzz help me to arrange the userid in ascending order, the userid contains both numeric and alphanumeric values, i am using vb dot net2005 and sql2000, when i arrange the userid it is coming...
1
by: chris fellows | last post by:
I have a C# webservice with a web method that accepts a string parameter that contains encrypted data. For some parameter values with non-alphanumeric values then the web method fails with an HTTP...
3
by: Paul73 | last post by:
Hi everyone, I'm hoping someone can help me. I've created a windows app that inserts data into a sql database. The data comes from textboxes. This is a simple app that will only be used by...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.