Update a column

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Thulasiraman
    New Member
    • Jun 2007
    • 2
    #1

    Update a column

    Hi All,
    I am New to this Group,I need a solution for a problem,Waiting for ur reply..
    My Problem is

    I have a column , Which has Names starts with alphabets, Now i want to generate Auto id fields according to the first letter of the name

    Suppose a Name starts with Arun My Id field should Be A001
    Like wise If its B it shuld be B001

    How can i solve this issue.
    Tags: None
    • Vidhura
      New Member
      • May 2007
      • 99
      #2
      Originally posted by Thulasiraman
      Hi All,
      I am New to this Group,I need a solution for a problem,Waiting for ur reply..
      My Problem is

      I have a column , Which has Names starts with alphabets, Now i want to generate Auto id fields according to the first letter of the name

      Suppose a Name starts with Arun My Id field should Be A001
      Like wise If its B it shuld be B001

      How can i solve this issue.
      You have to generate Auto-Number without using Identity Column

      Refer the following links for sample

      http://www.codeguru.co m/forum/showthread.php? p=1411375#post1 411375
      http://forums.devx.com/showthread.php? t=153423

        Comment

        Previous template Next
        Working...